Topic
  • 3 replies
  • Latest Post - ‏2010-06-17T16:58:17Z by Stan
Ed Yu
Ed Yu
1 Post

Pinned topic DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.0

‏2010-02-23T18:11:55Z |
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.

Ed.
Updated on 2010-06-17T16:58:17Z at 2010-06-17T16:58:17Z by Stan
  • joachim.stumpf@de.ibm.com
    2 Posts

    Re: DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.0

    ‏2010-03-22T16:14:51Z  
    Did you test it with v9 clients too ?
  • joachim.stumpf@de.ibm.com
    2 Posts

    Re: DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.0

    ‏2010-04-01T06:06:24Z  
    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.
    Jo
  • Stan
    Stan
    267 Posts

    Re: DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.0

    ‏2010-06-17T16:58:17Z  
    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.
    Jo
    Integration was provided between IBM Cloudscape and the DB2 Runtime Clinet to support ODBC until IBM Cloudscape was discontinued after the 10.1 release (http://www-01.ibm.com/common/ssi/rep_ca/0/897/ENUS907-040/ENUS907040.PDF).

    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.