471,601 Members | 891 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,601 software developers and data experts.

SQL DTS to DB2

I created an ODBC connection to a DB2 instance running on Linux. Using SQL 2000 DTS package,I can read data from DB2 and populate SQL tables. However when I try to write to DB2 tables, I get the error:

The number of failing rows exceeds the maximum specified. [IBM][CLI Driver] CLIO15OE Driver not capable. SQLSTATE=S1C00

The DTS is able to create tables on DB2, but can't populate them. Also, using Microsoft Access, I can write from SQL to DB2. Why can't I do it with the SQL 2000 DTS?

I've tried DB2 versions 7 and 8.

Thanks.
Aug 21 '06 #1
0 1285

Post your reply

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.