Copy DSN's one machine to another? 1

[maryb0224]

Lets say I have one machine with 20 System DSN's configured through the Microsoft ODBC Administrator. I get a new machine and I want to have the same 20 System DSN's on the new machine. Is there a file that can be copied from one machine to the other?

I notice that ODBC.INI contains all of my configured Data Sources - but when I move that file from one machine to the next, they don't show up in the ODBC Administrator GUI. I also notice that if I delete one of the DSN's that does show up in the ODBC ADministrator GUI, the the modified date of ODBC.INI changes, but that none of the 20 configured ones show up.

Do I really have to reconfigure all the DSN's???

 

[Bennie47250]

Did you ever find a way to move the DSN's?

 

[ArtieChoke]

The only way I know to replicate DSNs (except for file ones) is to export them from the registry and import them on the new machine.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[FancyPrairie]

It sounds like you are using either user or system dsn's. Setup a file dsn (done the same way) and save the file out on a server that everyone has access to. Then you don't have to worry about distributing them, etc.