pr**********@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
More information:
have Microsoft Access 2000 and an Oracle database created from
9.2.0.1.
I am trying to export a table from Microsoft Access 2000 to Oracle.
I get error:
ODBC -- Call failed
[Oracle][ODBC][ORA-12571]: TNS:packet writer failure [#12571).
When I look in database it creates the table and indexes successfully
but no rows are exported?
I have verified connectivity through SQLPLUS and it works fine.
Also, in the same Oracle database instance I have tried to export
serveral tables from NothWind Database and they export without
any problems. These tables do contain Memo/Clob types.
Any ideas on how to troubleshoot the problem will be greatly
appreciated.
I don't know how to troubleshoot this error?