ODBC

[Intern]

Does anyone know how to create an ODBC connection through VB code.

my goal is to have 5 ODBC connections create the first time a program runs,
but I honestly have no clue where to begin.

Thanks

[Chris Ross]

You are talking about DSN configuration? The easiest way to set up ODBC DSN
settings is to set them up on your machine first, ensure they work, then
export the registry settings to a reg file that you can deploy with your
app, (either in P&D Wiz, or Visual Installer). You can find the registry
keys for ODBC DSN settings at -
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

Watch out for different OS's though... NT's setting may be different than
95, or 98, etc. Also, if the client PC has a name conflict with a DSN that
you are trying to set up, the registry file you are deploying may overwrite
the existing values on the client.

Hope this helps...

Chris Ross


Intern <ledzepplin1979@yahoo.com> wrote in message
news:3948ccf0$1@news.devx.com...
>
> Does anyone know how to create an ODBC connection through VB code.
>
> my goal is to have 5 ODBC connections create the first time a program
runs,
> but I honestly have no clue where to begin.
>
> Thanks
>
>