Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC Set-up (2000)

    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!

  2. #2
    Lounger
    Join Date
    Nov 2002
    Location
    Farnborough, Hampshire, England
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC Set-up (2000)

    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.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC Set-up (2000)

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •