Deploying System DSN to Multiple PCs

#1

Is there any way to deploy System DSNs to multiple PCs?

I'm in a windows xp client environment with sql server 2000 running on a
windows server 200 box.

Thanks for any help.

#2

System DSNs are stored in the registry under
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Try exporting the registry node
for the data source and run it on another computer to see if it works.

Roman

Roman Rehak, MCSD, MCDBA, MCSA
SQL Server Specialist
Competitive Computing
http://sqljunkies.com/WebLog/Roman

"Josh" <Josh (AT) discussions (DOT) microsoft.com> wrote

Quote:

Is there any way to deploy System DSNs to multiple PCs?

I'm in a windows xp client environment with sql server 2000 running on a
windows server 200 box.

Thanks for any help.

#3

Thanks for replying but that didn't work. I was thinking maybe there might
be a way to create a vbscript to create the system dsns.

"Roman Rehak" wrote:

Quote:

System DSNs are stored in the registry under
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Try exporting the registry node
for the data source and run it on another computer to see if it works.

Roman

Roman Rehak, MCSD, MCDBA, MCSA
SQL Server Specialist
Competitive Computing
http://sqljunkies.com/WebLog/Roman

"Josh" <Josh (AT) discussions (DOT) microsoft.com> wrote in message
news:FA14A0DA-A2C4-4779-ADDC-49F79016EF6E (AT) microsoft (DOT) com...
Is there any way to deploy System DSNs to multiple PCs?

I'm in a windows xp client environment with sql server 2000 running on a
windows server 200 box.

Thanks for any help.

#4

These articles might help you get going with this:
How To Create and Remove a DSN in Visual Basic
http://support.microsoft.com/?id=171146
How To Programmatically Create a DSN for SQL Server with VB
http://support.microsoft.com/?id=184608

-Sue

On Sun, 27 Feb 2005 21:47:01 -0800, "Josh"
<Josh (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Thanks for replying but that didn't work. I was thinking maybe there might
be a way to create a vbscript to create the system dsns.

"Roman Rehak" wrote:

System DSNs are stored in the registry under
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Try exporting the registry node
for the data source and run it on another computer to see if it works.

Roman

Roman Rehak, MCSD, MCDBA, MCSA
SQL Server Specialist
Competitive Computing
http://sqljunkies.com/WebLog/Roman

"Josh" <Josh (AT) discussions (DOT) microsoft.com> wrote in message
news:FA14A0DA-A2C4-4779-ADDC-49F79016EF6E (AT) microsoft (DOT) com...
Is there any way to deploy System DSNs to multiple PCs?

I'm in a windows xp client environment with sql server 2000 running on a
windows server 200 box.

Thanks for any help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Deploying System DSN to Multiple PCs

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Deploying System DSN to Multiple PCs - 02-27-2005 , 09:25 PM

Re: Deploying System DSN to Multiple PCs - 02-27-2005 , 11:16 PM

Re: Deploying System DSN to Multiple PCs - 02-27-2005 , 11:47 PM

Re: Deploying System DSN to Multiple PCs - 02-28-2005 , 06:34 AM