I am creating a VB.net Web application and trying to connect to an IMB DB2
Database and I get the following error:
Keyword Provider not Supported. Here is my code:
Dim DB2connectstring As String =

Can anyone give me some samples using ADO.NET with the Publishers database?
Thanks
Roshawn

I have an SQL server 2000 setup with english local and I have created a
database with the Turkish_CI_AS local.
Using the SQL Query Analyser I am able to use the database.
When I am trying to do the same using the .NET Framework 1.0, I get the

I'm running through a loop calling a stored procedure each time. I prepare
the SqlCommand before entering the loop and just change the param values in
the loop before each call to ExecuteNonQuery(). The problem I get is it's
taking anywhere from 1/4 - 1/2 second before each call is ...

Maybe this question looks stupid, but could anyone tell me if, and if so
how, it is possible to use the same sqlTransaction in more webpages.
Is it possible to store the sqlTransaction class in a session or viewstate?
It's because I need to create the following structure:

Problem:
When impersonation is set in the web.config file, I cannot establish an
OLEDB connection to the database from my ASP.NET v1.1 application.
(Unspecified Error.  Stack trace shows it happens on the ProcessResults

I would like to overwrite existing Datefield with an empty value. (with
update command)
In Access it could be done with: MyDateField.Value= vbEmpty, for SQL server
it goes with: MyDateField.Value=DBNULL.Value with ADO.NET in VS2003.

just a quick one guys. using a winform (not web) (VB.NET) client app.
the dataset is declared public and is filled at a this point and displaying in a datagrid. if i make any changes and try to call the dataAdapter.Update(dataset) method
i get the error at the bottom.
Try

I am invloved in a re-engineering project, which requires a table with
900000 records to be fetched in memory. I am using DataReader for the
same but surpisingly; it is taking 10 minutes to fetch 80000 records.
On debugging, I noticed that DataReader is getting slow in fetching the

SqlParameter converts the value to a CLR type. But this is a problem
while storing OUTPUT parameter values to CLR variable of a type from
System.Data.SqlTypes namespace. For example, the following obviously
does not work

How to let the user know the progress while accessing BLOB type data? The
feedback such as the number of bytes readed/written to database.
Regards,
ZhangZQ

I just thought I should share this with you guys:
This an investigation that I conducted the problem of
System.Data.ConstraintException: Column 'XYZ' is constrained to be
unique.  Value '1' is already present.

Aloha,
  I'm writing a desktop/Windows application using VB.net (MSDE 2003).
I'm trying to use integrated security with a User Id and password to
connect to a SQL Server. The SQL Server administrators insist that I

We developed an application library to support our system development. This
library, when perform its functions, would access a database to lookup
validation parameter values (we didn't cache the table right now). Normally,
each of its member functions will need to look up multiple ...

I use SqlHelper.Execute Scalar a lot in my apps. I need now to use it with
SqlTransactions.
ie: I am currently using code from your:
// Microsoft Data Access Application Block for .NET