SQLDTS2000
Programmer
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
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
