I would like to connect to a MySQL database running on a Linux machine called pigster, so on my vb.net development machine running win2000 I have set up a system dsn use MySQL ODBC 3.51 Driver called GilstoneMySql, and set up grants in MySQL all Tested ok.
In vb.net the connection string is...
I need to record the value of the timestamp field in VB.Net to provide validation in pending update procedures using a DataReader/DataRow.
Can this be done or is there a better way?
Many thanks
I have 2 examples of simple stored procs the first works and the second gives the error "The OLE DB Provider 'MSDASQL' inicates that the object has no columns"
Ex.1
SELECT * FROM OPENQUERY(LinkedServer,'Select de_refno,de_name FROM Departmt ORDER BY de_refno')
Ex.2
SELECT * FROM...
As far as i know the only way is SET CONFIRM OFF and put an inkey() trap in the object valid clause to so as to control the cursors flow.
Hope this helps
FoxPro 2.6 is just a list of .dbf tables and not part of a single Database. Can a catalog or schema be created to allow the connection? as I cannot create a four-part name as it stands now.
I have 2 examples of stored procs the first works and the second gives the error "The OLE DB Provider 'MSDASQL' inicates that the object has no columns"
Ex.1
SELECT * FROM OPENQUERY(LinkedServer,'Select de_refno,de_name FROM Departmt ORDER BY de_refno')
Ex.2
SELECT * FROM...
Thanks Linguinut, I had been lead to believe that this was not possible and that "Linked Server" was the way to go.
However, I have trawled through my Wrox books but cannot find how to connect to a local System.DSN.
Is this the way you suggest.
Your help much appreciated
I have to import and modify Foxpro 2.6 .dbf files in a .NET application using SQL 2000. Is it best to use "Linked Server" as sugested by MS or can a schema file be used and if so whats the best software to create it.
All replies most appreciated.
I have to import and modify Foxpro 2.6 .dbf files in a .NET application using SQL 2000. Is it best to use "Linked Server" as sugested by MS or can a schema file be used and if so whats the best software to create it.
All replies most appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.