I am using SQL Server 2000 and .Net Frame Work1.1.
I have implemented the transaction based activity using the following
syntax.
gtrnSQLDB = gcnnSQLDB.BeginTransaction(IsolationLevel.ReadUncommitted)

I read there is no difference between calling Close vs. Dispose on
Connection objects.
Is this true?

We are having problems where connections in a connection pool are being
exausted. We are using the Microsoft Application Block SQL Helper class and
are seeing the failure in the following method:
public static int ExecuteNonQuery(string connectionString, CommandType

I have a table in a sql server db that contains thousands
of records.  So, I don't want to fill a dataset with
thousands of records.  But I would like to get the count
of records in the table.  One way I can think of would be

I have a basic selection query (SELECT * FROM Tbl WHERE [Code] LIKE val")
that is throwing an OleException when 'val' is the string
"It'll-be-ok"
It thinks that I'm using operator || I guess..  I dunno.  The exact error

I'm having a hard time finding something explicit which indicates
whether Max Pool Size is intended to mean 'maximum number of
connections within a pool, where distinct connection strings means
distinct pools' or 'maximum total number of connections which can be

I am having a problem with ExecuteNonQuery.
I have this code:
       Try
           strsql = "Insert into [Action] values (" &

I am starting a .NET project and am wondering if anyone has experience with
using ADO.NET to access a  SQL Server 7/NT server.  If so, were there any
issues?

Dim conn As New SqlConnection
Dim comm As New SqlCommand
conn.ConnectionString = "Data Source =(local);Initial
Catalog=Olympia;Integrated Security=True;"

I'm creating my first "real" Windows Forms application.  I'm having some difficulty binding a DataView to my custom control.  I can do it just fine if I bind directly to the DataTable, and it behaves as I want.  (Multiple controls on the screen, each one bound to a different row ...

I am having a problem getting data from a MySQL database using an ODBC
connection.  The below code
works 100% in a Windows Form but not in my ASP.Net Web Form.  It returns the
error "The Connection

I've seen people have this issue before, but it has always been intermittent for folks.  Mine isn't (some students do work, but several cause the exception every single time).  What goes on is that I try to pull up data on a student, but when DbDataAdaptor.Fill is called, I get ...

I have an untyped DataSet object and a typed DataSet class, by design the
structures match, I want to cast!!! my untyped DataSet object into with my
typed
DataSet class. Can I do this, whitout having to manually copy the data

   I have a protected Access Database (with different tables) and an user
with different permisions for every table. How can I get the user's
permisions for every table?
Daniel

I have an untyped DataSet object and a typed DataSet class, by design the
structures match, I want to cast!!! my untyped DataSet object into with my
typed
DataSet class. Can I do this, whitout having to manually copy the data