MS SQL Server ODBC - automate way to build an odbc connection

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

automate way to build an odbc connection

Sam

2006-10-24, 6:40 pm

is there is an automate way to build an odbc connection without usin the
windows "odbc data source administrator"?

thanks

Sue Hoegemeier

2006-10-24, 6:40 pm

You can programmatically create DSNs - they are just
registry entries really. Most of the examples you can find
just write to the registry. Here are a couple of samples
that should have enough information to get you going:
How To Programmatically Create a DSN for SQL Server with VB
http://support.microsoft.com/?id=184608

How to Create ODBC DSN on multiple SQL server machines
http://www.databasejournal.com/feat...cle.php/2238221

-Sue

On Thu, 28 Sep 2006 15:23:24 +0200, "Sam"
<focus10@zahav.net.il> wrote:

>is there is an automate way to build an odbc connection without usin the
>windows "odbc data source administrator"?
>
>thanks
>

Sponsored Links