By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

some help with ODBC or OleDB please

P: 2
Hi,

We currently have a database program written in C++ that can communicate with Oracle, MySQL and Microsoft Access and Microsoft SQL server through either ODBC and through OleDB (the latter only for Oracle and Microsoft SQL server). I've been asked to implement DB2 support and I'm having some troubles.

For the ODBC:
Creating and dropping tables works fine, also adding columns to tables works fine, but if I try to insert a row through the IRowsetChange->InsertRow method I get the error:
CLI0150E Driver not capable. SQLSTATE=S1C00

I'd be really thankfull for anyone suggestioning likely causes or providing hints to were I can get more info.

Kind regards,

Michael
Sep 10 '07 #1
Share this Question
Share on Google+
2 Replies


P: 7
The culprit is OBDC driver. I too had a similiar issue where I tried connecting a DB2 databae with ODBC driver. Though I was able to establish the connectivity, any query using date fields comparison failed. - Search this form under "REMEDY" or "EPOCH"
Sep 11 '07 #2

P: 2
The culprit is OBDC driver. I too had a similiar issue where I tried connecting a DB2 database with ODBC driver. Though I was able to establish the connectivity, any query using date fields comparison failed. - Search this form under "REMEDY" or "EPOCH"
Thank you for your reply. But I don't think date fields are the problem here, I removed any date fields from my database and every reference to them from our program and I still have the same error. I'm using the IBM ODBC provider (v9), I'm thinking about trying the microsoft one, but I'm having difficulties configuring it, it is asking for initial catalog and package collection fields which I don't know how to answer even after reading the MSDN documentation.

Kind regards,

Michael
Sep 11 '07 #3

Post your reply

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