Looks like the full/lite DB2 8.2 runtime client connects to derby 10.5.3.0 fine but has trouble recognizing table names with an underscore. So I had to configure CLI and add a keyword 'UNDERSCORE' with a '0' value to allow ODBC see these tables from derby.
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Ed Yu 270002YVNT
Pinned topic DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.0
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-06-17T16:58:17Z at 2010-06-17T16:58:17Z by Stan
firstname.lastname@example.org 120000F75T2 Posts
Re: DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.02010-04-01T06:06:24ZThis is the accepted answer. This is the accepted answer.Hi Ed,
on which plattform do you test and how. I did similar thing with DB2 9.5 client, but i have problme with C++ cli programming to get it connected.
Stan 120000HAGM267 Posts
Re: DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.02010-06-17T16:58:17ZThis is the accepted answer. This is the accepted answer.
- email@example.com 120000F75T
Because IBM Cloudscape was an unaltered release of Apache Derby the DB2 CLI worked smoothly with Derby 10.0 and 10.1. After that the integration has not been maintained and I would expect increasing problems with using the DB2 CLI with each new release of Derby.