Pushing out ODBC via Group Policy

sparkis
sparkis used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

Author

Commented:
Actually the settings are not there that are under HKey_currentuser....

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.
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.
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Author

Commented:
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

Author

Commented:
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.

Author

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial