ODBC connection updates

[Guest Dave Navarro]

Each time we add a new database to SQL and create an ODBC system

connection, we have to re-create that connection on all of our servers

so that scripts running on those servers can access the database.

 

Is it possible to auto-migrate ODBC connections from one box to another

and keep everything synched?

 

--Dave

[Guest Anthony]

Re: ODBC connection updates

 

The ODBC connections are just registry keys, so you can export them and then

apply them on other machines. You could also script it, as here:

http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov04/hey1110.mspx

Hope that helps,

Anthony, http://www.airdesk.co.uk

 

 

"Dave Navarro" <dave@no.way.dude> wrote in message

news:MPG.21a3a1e0111bcb3998968e@msnews.microsoft.com...

> Each time we add a new database to SQL and create an ODBC system

> connection, we have to re-create that connection on all of our servers

> so that scripts running on those servers can access the database.

>

> Is it possible to auto-migrate ODBC connections from one box to another

> and keep everything synched?

>

> --Dave

[Guest Dave Navarro]

Re: ODBC connection updates

 

In article <uknzqnkJIHA.4880@TK2MSFTNGP03.phx.gbl>,

anthony.spam@spammedout.com says...

> The ODBC connections are just registry keys, so you can export them and then

> apply them on other machines. You could also script it, as here:

> http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov04/hey1110.mspx

> Hope that helps,

> Anthony, http://www.airdesk.co.uk

>

>

> "Dave Navarro" <dave@no.way.dude> wrote in message

> news:MPG.21a3a1e0111bcb3998968e@msnews.microsoft.com...

> > Each time we add a new database to SQL and create an ODBC system

> > connection, we have to re-create that connection on all of our servers

> > so that scripts running on those servers can access the database.

> >

> > Is it possible to auto-migrate ODBC connections from one box to another

> > and keep everything synched?

 

Thanks for the link.

 

So, what I need to do is write a script to synch the registry entries

for ODBC connections between the servers and stick it in the scheduled

tasks or something.

 

This should be interesting. :)

 

--Dave