all groups > dotnet odbc.net > january 2005
Concurrency error with mySQL
Posted by Tim Marsden at 1/27/2005 10:05:04 AM
Hi,
I am using ODBCNET to update a mySQL table.
I update the table using a DataAdapter. Setting the Update, Insert and
Delete commands manually.(Optimistic updates)
If I change a row in the datatable, changing the value of a column to the
same value as the original.
The changed row appea... more >>
connection string for Text driver
Posted by Peter_Smyth at 1/26/2005 2:49:01 PM
I'm trying to connect to a text file ( c:\test\table1.txt).
My connectionstring looks like
connectionstring = "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"DBQ=C:\test;DriverID=27"
On trying to open the connectin I get an error message about not being ab... more >>
Timberline (Pervasive) ODBC Access
Posted by Robert Porter at 1/23/2005 4:18:27 PM
Is anyone else out here working with Timberline version 7.x,8.x or 9.x and ODBC and .NET? If so any advice to offer? I am working with a number of older VB 6 applications that interface (mostly just read) Timberline data stored in a Pervasive SQL database that I am porting to VB.NET.
Experiment... more >>
SQLSetConnectAttr Woes
Posted by Robert Porter at 1/23/2005 3:11:15 PM
Hi,
The following code works, it populates the dataset with the anticipated data, but the OdbcConnection objects InfoMessage always generates the following error message.
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[Microsoft][ODBC Driver Manager] The driver doesn't ... more >>
Data Connection problem
Posted by TOM at 1/11/2005 8:49:32 AM
When i am trying to connect to my SQL server using the
SQLdataadapter or the OLEDBdataadapter, VB tells me that
i can not connect to it. I can not even make a new
connection. The Error is: Provider cannot be found. May
not be installed properly.
Any Ideas?
Thanks
Tom... more >>
|