Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

oledb error

2 posts in General Discussion Last posting was on 2006-06-22 02:53:23.0Z
Mark Posted on 2006-06-19 10:48:50.0Z
From: "Mark" <mark@3wt.nl>
Newsgroups: ianywhere.public.general
Subject: oledb error
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.144.254.66
X-Original-NNTP-Posting-Host: 213.144.254.66
Message-ID: <44968112$1@forums-1-dub>
Date: 19 Jun 2006 03:48:50 -0700
X-Trace: forums-1-dub 1150714130 213.144.254.66 (19 Jun 2006 03:48:50 -0700)
X-Original-Trace: 19 Jun 2006 03:48:50 -0700, 213.144.254.66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5440
Article PK: 1486

Hi,

I have to communicate between sql server 2005 and asa 9 using the new dts in
sql server. However, there seems to be something wrong with the oledb driver
for asa 9.

When i try to execute the following problem occurs :

Error 0xc0202009: Source - contact[1]: An OLE DB error has occured. Error
code : 0x80040E21

Error 0xc020204a: Source - contact[1]: Unabtle to retrieve column
information from the data source.

Is there a solution (updated driver ?) for this ?


Greg Fenton Posted on 2006-06-22 02:53:23.0Z
From: Greg Fenton <greg.fenton_nospam_@ianywhere.com>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: oledb error
References: <44968112$1@forums-1-dub>
In-Reply-To: <44968112$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <449a0623$1@forums-1-dub>
Date: 21 Jun 2006 19:53:23 -0700
X-Trace: forums-1-dub 1150944803 69.193.72.112 (21 Jun 2006 19:53:23 -0700)
X-Original-Trace: 21 Jun 2006 19:53:23 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 25
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5451
Article PK: 1496


Mark wrote:
> Hi,
>
> I have to communicate between sql server 2005 and asa 9 using the new dts in
> sql server. However, there seems to be something wrong with the oledb driver
> for asa 9.

Just curious, but why do you *have* to use DTS ?
To me, using a tool that is created by people specifically not
interested in inter-database operability is an exercise in futility.
Why not go with SQL Anywhere tools which are?

> Error 0xc0202009: Source - contact[1]: An OLE DB error has occured. Error
> code : 0x80040E21

Have you looked at MS's help for this error code?

greg.fenton
--
Greg Fenton
Random Dude
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/