| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC connection from Access to 8.0.5
Did you set up your ODBC info in your ODBC data sources control panel? Is it set up as a system or user DSN? Trace this one step at a timecan you connect from that client to the oracle server via the oracle software; do you have a valid user/password set up there; from Access, when you choose link to external data/odbc sources, can you browse any tables in the Oracle machine?
On Sun, 21 May 2000 21:04:50 -0700, "Jim Keesee" <jkeesee_at_uswest.net> wrote:
>I hope someone can help me figure out why the Oracle ODBC driver on my LAN
>keeps giving me errors. At home I installed the Oracle Client 8.0.5 via
>TCP/IP and can connect to the Oracle server just fine with my MS Access
>front end. However, on the LAN when I try to connect via ODBC from Access I
>keep getting error messages. 1) The oracle(tm) client and networking
>components were not found. These components are supplied by oracle
>corporation and are part of oracle version 7.3 (or greater) client software
>installation. You will be unable to use this driver until these components
>have been installed. 2) OCI.DLL
>One of the library files needed to run this application cannot be found.
>
>Does anyone have an idea what can be causing me to get these errors. I
>loaded the same Oracle client on my workstation on the LAN as I did at home
>and no good.
>
>Thanks in advance for the assistance.
>
>--
>Jim Keesee
>jkeesee_at_uswest.net
>
>
>
 |
 |