ODBC Connection

I apologize if this isn't the right place to ask this,
but I'm looking for a way to copy an SQL/Server ODBC
connection from one PC to another (actually, many
others). I tried copying the ODBC.INI file but that
didn't seem to work. That seems to be the only file that
is updated when I create a new connection, so I was
hoping that was all I needed. Is this possible ? Or do I
have to go through the ODBC setup on each PC ?
The user and system DSN definitions are stored in the following two registry
keys:
HKLM\SOFTWARE\ODBC\ODBC.INI\
HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\
Mike O.
"Dave Ruhl" <anonymous@.discussions.microsoft.com> wrote in message
news:da9a01c41131$4a3d7d70$a001280a@.phx.gbl...
> I apologize if this isn't the right place to ask this,
> but I'm looking for a way to copy an SQL/Server ODBC
> connection from one PC to another (actually, many
> others). I tried copying the ODBC.INI file but that
> didn't seem to work. That seems to be the only file that
> is updated when I create a new connection, so I was
> hoping that was all I needed. Is this possible ? Or do I
> have to go through the ODBC setup on each PC ?

ODBC Administrator app fails only on SQL Server

Make sure this isn't a rights-issue
You could reinstall mdac 2.8 or sql server client.

>--Original Message--
>Hello,
>I am on an XP SP1 system and when I use the ODBC
Administrator application
>to establish a new SQL Server DSN the process fails.
>After launching the ODBC Administrator I push the "Add"
button and select
>"SQL Server" from the list of available drivers. When I
then push the
>"Finish" button I am immediately returned to the initial
ODBC Administrator
>window. That is, I am never presented with the dialog
box for configuring
>the SQL Server DSN. If I select a Sybase, MS Access or
Oracle DSN I do get
>the expected configuration dialog box. Under W2000 I get
a dialog box for
>configuring a SQL Server DSN and on a different XP SP1
system I also get the
>configuration dialog box. All of this suggets that
something has gone wrong
>on this particular XP SP1 box. Can anyone tell me what's
happened and how
>to fix this?
>Thanks very much for the help.
>Al Koch
>AlKoch@.MyRealBoxREMOVEALLTHESECHARS.com
>
>.
>
Thanks for the reply. It wasn't a right issue since I was logged in as an
Admin. However your suggestion to reinstall MDAC fixed the problem I a
curious though, are you aware of what might have triggered the loss of
(only) the SQL Server ODBC facility?
Thanks,
Al
|||I can only guess
-Sql2000 has been updated to SP3a
(Perhaps the old driver was one for sql server 7)
-WindowsXP had a fair share of updates as well.
-Perhaps a anti-virusprogram was running during install of
mdac/updates

>--Original Message--
>Thanks for the reply. It wasn't a right issue since I
was logged in as an
>Admin. However your suggestion to reinstall MDAC fixed
the problem I a
>curious though, are you aware of what might have
triggered the loss of
>(only) the SQL Server ODBC facility?
>Thanks,
>Al
>
>.
>
|||Thanks for the possible causes and thanks again for the help!
Al
"gandalf" <anonymous@.discussions.microsoft.com> wrote in message
news:307801c4b03d$6f50dac0$a301280a@.phx.gbl...
> I can only guess
> -Sql2000 has been updated to SP3a
> (Perhaps the old driver was one for sql server 7)
> -WindowsXP had a fair share of updates as well.
> -Perhaps a anti-virusprogram was running during install of
> mdac/updates
>