469,160 Members | 1,830 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,160 developers. It's quick & easy.

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 1256

Post your reply

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

By using this site, you agree to our Privacy Policy and Terms of Use.