sparkis
asked on
Pushing out ODBC via Group Policy
I need to create a new ODBC connection for all clients in a windows 2003 domain env. all running windows XP. I have been doing some research and it looks like I need to export the registry settings on one configured machine and use that when creating and ADM template. I cannot find the settings in my registry - where it is configured. where is the location?
Thanks - SJMP
Thanks - SJMP
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's correct the same path under currentuser contains the user ODBC's and the one i mentioned before contains the system ODBC's. If you export and import the key your settings will be transferred but it will not show up under the odbc management interface.
ASKER
so how do I do this? I need to get it installed on everyones machine. Authentication is not an issue since the sql db is using windows authentication.
If it's a user ODBC you can import the reg key through a login script with /s for silent
regedit.exe /s path of .reg file
regedit.exe /s path of .reg file
ASKER
how do I know the difference? User/System?
We do use a login script that I could add this too. Would you be able to give me the script I need? I can open a new question for pts if you like.
We do use a login script that I could add this too. Would you be able to give me the script I need? I can open a new question for pts if you like.
ASKER
Also when I executed the exported reg settings there is nothing added in User Data Sources or System DSN
Yes, don't worry about what shows up in the interface. Just try to use it and it will work.
ASKER
But I tried exporting they key, deleting it from the registry. And even through executing it did work. there was not new connection put in ODBC conectors.