Search results for query: *

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

Many thanks Christiaan, I'll look into the method you suggest Clive Porter Uk

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.

Thanks James, all I want to achieve is to update the FoxPro files that the SELECT command returns. Can this be achieved thro a stored proc?

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.