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...
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...
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.