ODBC Set-up (2000)

Topic

New Reply

I hope this is an easy one. I have several ODBC links to Oracle databases and periodically I have to grant new users access to the database. For things to run properly, I have to go to the ODBC Administrator and define new data sources one by one. Is there a file I can copy from my PC and paste to the new user’s PC that will create the data sources without making me create them individually?

Thanks!

Reply | Quote

Replies

I’d started looking at a solution for this a while ago, albeit for ODBC connections to SQL Server. I got as far as creating an Excel spreadsheet where you could list the connection details, and some code that would put them into the Registry.

It’s been a while since I looked at it, and I can’t even remember if it works or not. If you don’t get any other answers and you’re really desperate, I’ll try to strip all the rubbish out of it, and post it on here.

Reply | Quote

No worries. I’ll just create a document explaining how to do it…I just figured it was worth throwing it to the posting world.

Thanks!

Reply | Quote