Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Oracle ODBC (XP)

    I work at a system where the main database is Oracle 7 running on a vax. Till now I was able to use Access as a front end through ODBC when I was running Windows 2000. When I just upgraded my computer to Windows XP we could not get a driver that works from XP to the backend.
    Any ideas or experience with this?
    Thanks

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Oracle ODBC (XP)

    I believe that driver is normally installed with Office - were you previously running Office 2000 and now you are running Office XP/2002?
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oracle ODBC (XP)

    I was running office XP under Windows 2K. When I got a new computer that runs Win XP and office XP, the database administrator for the Oracle tried installing the different drivers for the ODBC and something from Oracle called SQL Net. They would not connect to the existing version of Oracle that we have. Trying to install the older ones, would not work under Win XP.
    Thanks

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Oracle ODBC (XP)

    I've not had any experience in working with the drivers supplied by Oracle - we've always used the Microsoft Oracle drive and had no problems. How are you connecting to the Oracle tables - with ODBC drivers or with OLE DB drivers?
    Wendell

  5. #5
    Lounger
    Join Date
    Oct 2002
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Shot in the dark

    We connect to Oracle 8i with ODBC.

    We are always having to place and replace TNSNAMES.ORA in

    ORANTNETWORKADMIN

    HTH.

  6. #6
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oracle ODBC (XP)

    attached is a screen shot of what I get when I try to use the MS driver:
    Attached Files Attached Files

Posting Permissions

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