Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tdcnorge.no!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: "Alan" <not.me@rcn.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Some more problems with exporting Access Table in Oracle
Date: Sat, 1 Jan 2005 10:47:48 -0500
Lines: 28
Message-ID: <33nv1kF41pcf1U1@individual.net>
References: <1104520927.457862.5180@c13g2000cwb.googlegroups.com>
X-Trace: individual.net +dfxdJObv6kLD+hm6v7grwussO/p5rpI9KXbZYSnHGiUXOP3WG
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:232514


<premmehrotra@hotmail.com> wrote in message
news:1104520927.457862.5180@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.