SQL change to Sybase connection (Visual Basic 6 ) error appearing

[SQLDTS2000]

Hi,
I change the connectionstring by using Sybase driver instead of MS SQL. But I've an error occurred which says "Multiple-step OLE DB generated errors. Check each status value." The program was running with no errors encountered when the SQL driver was used but when it was change to a Sybase driver the above error appeared, also I found out that the value of the connectionstring is the one below. I don't know why it added the MSDSQL as the Provider.

ConnectionString="Provider=MSDSQL 1.0;UID=UserID;PWD=Password;Extended Properties: Driver={Sybase ASE Driver};UID=UserID;PWD=Password;SRVR=ODS;dbname=dbeord"


Thanks,
Charmine

 

[Nikita6003]

Hi Charmine,

check out this KB entry - might help

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q269495&

If the error's not on the connection but occurs later in yiour process, check for incompatible data such as NULLs or insufficient field size

HTH

Cheers
Nikki