Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    2

    Question Unanswered: Connection problems via ODBC

    I'm having problems connecting to Oracle 817 from MS Access using ODBC. In an existing Access DB with linked oracle tables the connection is successful but incredibly slow. If I create a new Access DB and try to get external data after entering the password for oracle it just sits there forever and never connects. Can anyone suggest what to do?

    Thanks in advance

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I had problems a while back with the odbc drivers on the "installation disk".
    Ensure you are using 8.1.7.4 ODBC drivers. This is a little over 1meg download from Oracle... This cured my problems ...

    HTH
    Gregg

  3. #3
    Join Date
    May 2004
    Posts
    2
    Thanks Greg for that info - current driver is 8.1.7.0 - so I will have the DBA install the one you suggest. Fingers crossed!

Posting Permissions

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