TOP POSTING is rude & confusing!
>
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
> news:0w4da.6942$FH2.2651_at_fed1read02...
>
>>Randy Harris wrote:
>>
>>>One of my client systems gets an Oracle error when it attempts to access
>
> an
>
>>>Oracle database from any MS Access client. I tried reinstalling MS
>
> Office
>
>>>with no change. I think the problem is in the Oracle client software.
>
> It
>
>>>immediately gets an Oracle run time error (214746259). Where can I go
>
> to
>
>>>learn more about this error? I'm completely lost on how to resolve this
>>>problem.
>>>
>>>--
>>>Randy Harris
>>>
>>>
>>>
>>
>>As ALWAYS, it helps immensely to know the OS, OS Version and
>>Oracle version being discuessed.
>>
>>It seems to me that while you know for sure that you have a problem,
>>you don't seem to have a clue as to exactly where the source of the
>>problem might reside. Therefore I suggest you attempt to do some
>>troubleshooting.
>>
>>I "assume" that you have the Oracle client s/w installed on your PC.
>>I'd 1st get SQL*Plus or a similar software sucessfully accessing the
>>Oracle database. This helps to ensure that Oracle & its listener are
>>properly configured & functioning. Without this capability you are SOL.
>>Come back after you've confirmed these work.
>>
>>HTH & YMMV
>>
>>
>>
>>HAND!
>>
>>
>
>
>
Randy Harris wrote:
> You're certainly correct, I supplied very little information. Let me try
> again.
>
> The client system is Windows 2000 Pro. It has Oracle 8.1.7 server installed
> on it, and several local databases. The local databases all work fine. The
> remote Oracle server (to which I can't get Access to connect) is also
> running 8.1.7. I can connect, however, to that server database with sqlplus
> and DBAstudio.
>
> Further diagnosis is a bit dicey at the moment. The system with the problem
> is a laptop, the instructor that uses it had to take it to catch a plane.
> The application that won't work is a critical one, I promised to have a
> solution for him when he returns.
>
> --
> Randy Harris
>
Is the problem with the specific PC?
Can you get any connection using ACCESS to any Oracle database?
If so, what is different between the case where it work & where it fails?
I "assume" that Access uses ODBC.
Can you get any other ODBC-based client (sofware) to connect to
any Oracle database?
Simply put, you need to individually test each piece in the chain
between the client that fails & the target database PLUS verify
that you know how to successfully configure & use each component.
Received on Sun Mar 16 2003 - 14:17:39 CST
