By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Some more problems with exporting Access Table in Oracle

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

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?

Nov 13 '05 #2

P: n/a
You must setup TNS Names in Oracle to recognize the Access Table.
Alternatively, create all the initial objects (tables included) in Oracle
and then "attach" the external Oracle tables you need.
Now, during an insert, update or delete, you are working with the actual
table in question.

<pr**********@hotmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
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

Nov 13 '05 #3

P: n/a

"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:UCVDd.29733$3m6.20015@attbi_s51...
You must setup TNS Names in Oracle to recognize the Access Table.
Alternatively, create all the initial objects (tables included) in Oracle
and then "attach" the external Oracle tables you need.
Now, during an insert, update or delete, you are working with the actual
table in question.


Chuck, this guy multi posted his question. He has already received a number
of replies in another newsgroup.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.