Create System DSN via batch file on login 1

[JZajda]

I don't know if I am asking in the right place, but I am hoping to create new and/or modify existing System DSNs via a batch file on login. We are switching Servers and will have to visit each work station if we can't do this via some sort of script. Any help would be appreciated. We are on Windows 2003 Server, Windows XP workstations and SQL Server 2000 SP3a.

Thanks,
Joy

 

[rsinj]

as long as the ODBC drivers themselves are installed on the machines, you can simply put all of your additions/modifications in a .REG file which will update the registry - assuming the users (or task you set up) have permission to update the registry.