Re: Some more problems with exporting Access Table in Oracle

From: Alan <not.me_at_rcn.com>
Date: Sat, 1 Jan 2005 10:47:48 -0500
Message-ID: <33nv1kF41pcf1U1@individual.net>

<premmehrotra_at_hotmail.com> wrote in message news:1104520927.457862.5180_at_c13g2000cwb.googlegroups.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
>

I have never seen an ODBC driver that suppports CLOBs, or any *LOB, for that matter. Received on Sat Jan 01 2005 - 09:47:48 CST