Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cp84
  • Content: Threads
  • Order by date
  1. cp84

    provider is not registered

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

    SQL2000 Timestamp Data Type

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

    I have 2 examples of simple stored

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

    OpenQuery/LinkedServer

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

    SQL 2000 server and FoxPro 2.6

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

    Import from Foxpro 2.6 to SQL2000

    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.

Part and Inventory Search

Back
Top