Oracle BE to XP FE (XP/2K)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote