sql server odbc: how to add ODBC DSN to multiple computers -- sql server odbc

how to add ODBC DSN to multiple computers

Joseph O'Brien
2/8/2006 2:44:50 PM

sql server odbc:

Hello. I need to set add an SQL ODBC System DSN to each computer on
our domain.

The suggestions I've seen so far involve setting up a GPO startup
script using VBScript to call an API, or a batch file using odbcconf.
I don't know VB, and I could find very little information about how to
use odbcconf.

I would appreciate it if someone could give me a standard solution, if
there is one. I'm a little new to this, so I wouldn't be surprised if
I were completely off the mark.

thanks,
joseph

Re: how to add ODBC DSN to multiple computers

Sylvain Lafontaine
2/11/2006 12:15:07 PM

If the use of a DSN is not really mandatory for your application, then using
a DSN-Less ODBC connection might be an easier solution.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

[quoted text, click to view]