I get :"An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll" at line
"Dim rec As Integer = cmd.ExecuteNonQuery()"  when running:
Dim cs As String

I have an application that has been in production for some time. I have a
coworker who recently updated to windows 2003 sp1. When he runs the
application he gets an exception here:
Exception StackTrace:

I'm trying to load a comma delimeter file into an sql database.  I've tried
the query analyzer and now I'm using VB.NET.  I get the same error when doing
both, "type mismatch".  I know where the issue lies.  The actually columns in
the table are more than the number of columns in ...

If I inspect the tables property of the DataSet returned from GetChanges() I
notice that it has all the table in it that were in the original DataSet
even though records didn't change in those tables.
Is there a way to tell it to return only the tables that did change?

I have an interest in minimizing the amount of data transfer between my
SQL server and my client in a networked environement.  I have a table
with a large amount of data that has foreign key values pointing into
other tables that I need data from.  The data from these child ...

OK here is my problem, i have a datagrid based on a Dataset/SQLDataAdapter
(created based on stored procs already in place)
When i click on the Delete button (built in template delete) in the datagrid
it does delete the record but the datagrid doesn't refresh even tho there is

I am trying to manage databound controls on a form with a TreeView as the
RecordSelection Source.  As long as I am navigating among rows that existed
when the form was openned, I can set the CurrencyManager position using the
following line of code:

I think I might be wishing for the impossible here or at least waiting
for Yukon, but I'm wondering if it is possible to catch a SQL Server
trigger as an event in a vb .net app? Not sure what would be involved
or how it would work considering the fact that the DB is disconected

Can we check how many datareaders are associated with the connection? If
yes, then how?
Thanks & Regards,
Vishesh Vyas

   I am using MSDE in my application. I used MS Access to set default
values for the tables in the database. However, when I try to get a new row
from that table through ADO.NET, no default values has been fetched. Am I
doing something wrong?

We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server ...

This is a repost of an earlier message. I have updated my discussions profile
to use my MSDN nospam alias that is linked with our MSDN subscription.
We originally discovered the bug in Windows 2003 after Win2k3 SP1 was
applied to the machines. However, since the original post, we ...

I have a simple request, I have 3 SQL Servers which are linked server. Data
is spread out over those 3 servers.
Some transactions must be spread on more than SQL server and then I do not
know how to do this as i think that one transaction (SqlTransaction) can be

I use ADO.NET and the Microsoft.Jet.OLEDB.4.0 oledb provider to connect to an
excel spreadsheet and export data into a dataset to populate a datagrid.
Right now I use Extended Properties =Excel 8.0 in the connection string. When
I deploy on a production server do I need to check ...

I have five related tables in SQL2K, with FK relations between them. I would
like to load all five into a DataSet, read AND update them, then sync the
changes to SQL2K. In effect, I would like to replicate the entire database
into a DataSet (it will always be a small database, so ...