Re: Deploying System DSN to Multiple PCs

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Roman Rehak (rrehak_at_OPPOSITEofCOLDmail.com)
Date: 02/28/05


Date: Mon, 28 Feb 2005 00:16:38 -0500

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@discussions.microsoft.com> wrote in message
news:FA14A0DA-A2C4-4779-ADDC-49F79016EF6E@microsoft.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.



Relevant Pages

  • RE: ODBC SQL Error Bulk Insert - Null values
    ... Create two new system DSNs. ... One that uses the ANSI setting and another that ... ODBC SQL Server Driver SQL Server Note: Bulk Insert through a view may ... unchecked the ANSI checkboxes on the database. ...
    (microsoft.public.access.externaldata)
  • Can I manage SQL Server 2000 with Mangement Studio Express 2005?
    ... I'm new to the MS SQL Server world. ... Can I use the current version of Mangement Studio Express (MSE) to ... I have created an ODBC system ... I can select from a list of system DSNs ...
    (microsoft.public.sqlserver.connect)