Home > Archive > MS SQL Server ODBC > February 2006 > how to add ODBC DSN to multiple computers









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 how to add ODBC DSN to multiple computers
Joseph O'Brien

2006-02-08, 8:23 pm

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

Sylvain Lafontaine

2006-02-11, 11:23 am

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


"Joseph O'Brien" <obrien1984@hotmail.com> wrote in message
news:1139438690.109709.324280@g47g2000cwa.googlegroups.com...
> 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
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com