Re: Some more problems with exporting Access Table in Oracle

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Sat, 01 Jan 2005 12:56:53 +0100
Message-ID: <br3dt01tgugoimdpddrj5s14t6ohu2mv3c@4ax.com>

On 31 Dec 2004 11:22:07 -0800, premmehrotra_at_hotmail.com wrote:

>I am using Access 2000 and Oracle 9.2.0.x on a Windows 2000. I have
>setup Oracle 9.2 ODBC Driver (I have not yet figured how to set
>Microsoft's Oracle ODBC driver).
>
>I am exporting a table from Access to Oracle and I get following error:
>
>ODBC Call Failed:
>ORA-12571: TNS Packet Failure Error
>
>I see table and its indexes created in Oracle. However, there are no
>rows populated.
>
>I see there are CLOB columns created in Oracle Table (Memo of Access is
>mapped to CLOB). Could CLOB be an issue?
>How does one troubleshoot an error like this.
>
>Thanks.
>
>Prem

Access 2000 also might not be compatible with Oracle 9i, and/or come with an ODBC driver supporting Oracle 8i only. CLOB could definitely be an issue
Unfortunately ora-12571 is a generic data communication error, trapped by sqlnet.
Troubleshooting should start with tracing the sqlnet connection. I have posted many, many times how to accomplish this. Search for trace_level_client on google.

Happy New Year to everyone

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Jan 01 2005 - 05:56:53 CST