OdBc system dsn change...

[VCPro]

i need to update system dsn across a set of 45 desktops pointing to a new database.

for ex;

we have testdsn that points to db1 on all 45 desktops xp.
how do i change that database to db2 on all of them?

tried using wsh. but, not working.

any ideas?

thx...

 

[ArtieChoke]

You can make a registry script that has the database name change and run it remotely on all the computers.

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

 

[VCPro]

Artichoke,

Thanks for the reply. To update registry on all computers one has to have admin privileges. Not able to figure that part out. Most of the users are not admin's on their desktops. These are non-IT users. How can impersonate the admin? Do you have an example anywhere?


Thanks,

 

[ArtieChoke]

The way we do it is to set them up as local admins on their own machine, then they can alter the registry when they are logged on to that machine. There might be a way to do it with some program in the NT resource kit, but I haven't had to resort to that. Our IT group does the dirty work after we figure out how to do it.

Maybe the brute-force way to do it is to visit each machine via regedit (you can log on remotely) under an admin account and change each one manually - it's definitely a drag, but otherwise, you gotta visit each machine in person!

If you have the resource kit, check for some remote registry batch update type of program.

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