Create ODBC entries from a file?

[Raumarik]

Just wondering if it's possible to export/import or even make an installer that creates ODBC entries in windows 2000/xp. I've got 300 workstations to do and don't really fancy doing them all one at a time if I can find a faster way!

Server 2003, clients I need to do this on are 2000 and XP. Any ideas?

 

[Otacon]

Push a vbscript out to do it via group policy. Bear in mind that without admin permissions, they will only be able to create in the UserDSN, not system. Though that shouldnt cause any issue.

[edit]Or you could do this as a one off:

http://www.databasejournal.com/features/mssql/article.php/2238221

 

[Raumarik]

Cheers Otacon will have a look at that