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

    Oracle BE to XP FE (XP/2K)

    I have been looking for a while for someone with Oracle linked to Access databases. I have oracle 7 running as a backend, and I cannot find a way to link through odbc to XP. Does anyone have any ideas about that? I am not sure if the issue is Access XP, or more probably Windows XP.
    Thanks

    Zave

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oracle BE to XP FE (XP/2K)

    Can you be more specific about the problem you're having? Do you have the Oracle ODBC drivers installed? You would normally get those from Oracle.
    Charlotte

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

    Re: Oracle BE to XP FE (XP/2K)

    I have oracle ODBC drivers installed. The Oracle DB is version 7. The system works on a Win 2K system, with Access 2K. When I try to connect from an XP machine running Access XP I get the following error message in the attached picture.
    Thanks
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oracle BE to XP FE (XP/2K)

    I know with Oracle 8i along with the ODBC drivers you have to have Net8 assistant from Oracle installed on the PC with the front end application.
    The ODBC drivers alone won't connect to the back end.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oracle BE to XP FE (XP/2K)

    I've got lots of Oracle 8i and 9i database connecting from my Access XP databases

    There are a whole heap of possible causes for the failure :-(
    - have you got the Oracle client installed on you PC ?
    - does your Oracle TNSNAME.ORA have an entry for the database you're trying to connect to ?
    - what version of the Oracle ODBC driver are you using (check in the DSN for the Drivers tab)
    - at the command prompt , can you TNSPing the Oracle database ?

    Cheers,
    Steve C.

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

    Re: Oracle BE to XP FE (XP/2K)

    When the back end people are in I will try these ideas. Thanks

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Oracle BE to XP FE (XP/2K)

    You do need to install either Net8 or SQLNet on the client machine(s) to connect. SQLNet is what comes with Oracle 7 but I have used Net8 to connect to Oracle7 databases without any problems.
    Hope that helps.
    PS If you have a P4 machine, there was at one time a bug with the Oracle 8 client installer (not sure about 7) which caused the installation to fail. The solution is to copy the files to disk and rename the JIT compiler as I recall, but if you need exact details let me know and I'll dig them out.
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: Oracle BE to XP FE (XP/2K)

    Thanks a lot. This sounds like a solution and I will ret it after the weekend

Posting Permissions

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