Home All Groups Group Topic Archive Search About
Author
8 Mar 2006 6:50 PM
Martha Hoffmann
Is it possible to configure an odbc link from vb 6 code?

Thanks,
Martha Hoffmann

Author
8 Mar 2006 11:01 PM
ralph
"Martha Hoffmann" wrote:

> Is it possible to configure an odbc link from vb 6 code?
>
> Thanks,
> Martha Hoffmann
>


Could you perhaps provide a tad bit more information as to what it is you
want to do?

Based on what you have asked so far, I would have to say - Maybe.

-ralph
Author
9 Mar 2006 4:33 AM
MikeD
"Martha Hoffmann" <mhoff***@gcwda.com> wrote in message
news:OOy10EuQGHA.4688@TK2MSFTNGP11.phx.gbl...
> Is it possible to configure an odbc link from vb 6 code?

Are you asking how to progammatically create a DSN? If so, my first
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