|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
vb 6 and odbcIs it possible to configure an odbc link from vb 6 code?
Thanks, Martha Hoffmann "Martha Hoffmann" wrote: Could you perhaps provide a tad bit more information as to what it is you > Is it possible to configure an odbc link from vb 6 code? > > Thanks, > Martha Hoffmann > want to do? Based on what you have asked so far, I would have to say - Maybe. -ralph "Martha Hoffmann" <mhoff***@gcwda.com> wrote in message Are you asking how to progammatically create a DSN? If so, my first news:OOy10EuQGHA.4688@TK2MSFTNGP11.phx.gbl... > Is it possible to configure an odbc link from vb 6 code? recommendation is to use a dsn-less connection string. That way, it's not even an issue. If you MUST use a DSN (or even ODBC, which you should also consider dropping), see the following: How To Programmatically Create a DSN for SQL Server with VB http://support.microsoft.com/kb/184608/en-us How To Create and Remove a DSN in Visual Basic http://support.microsoft.com/kb/171146/EN-US/ How To Set Up ODBC Data Sources When Distributing Apps http://support.microsoft.com/kb/123008/EN-US/ Again, though, I encourage you to look into getting away from ODBC, or at least use a dsn-less connection. -- Mike Microsoft MVP Visual Basic |
|||||||||||||||||||||||