Some more problems with exporting Access Table in Oracle

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

re: Some more problems with exporting Access Table in Oracle

premmehrotra@hotmail.com wrote:[color=blue]
> 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[/color]
error:[color=blue]
>
> 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[/color]
is[color=blue]
> mapped to CLOB). Could CLOB be an issue?
> How does one troubleshoot an error like this.
>
> Thanks.
>
> Prem[/color]

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?

re: Some more problems with exporting Access Table in Oracle

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.

<premmehrotra@hotmail.com> wrote in message
news:1104521022.532371.12050@c13g2000cwb.googlegro ups.com...[color=blue]
> 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
>[/color]

re: Some more problems with exporting Access Table in Oracle

"Chuck Insight" <j.gillham@insightbb.com> wrote in message
news:UCVDd.29733$3m6.20015@attbi_s51...[color=blue]
> 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.[/color]

Chuck, this guy multi posted his question. He has already received a number
of replies in another newsgroup.