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

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
    ACCEPTED ANSWER

    Re: DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.0

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

    Re: DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.0

    ‏2010-04-01T06:06:24Z  in response to Ed Yu
    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
      ACCEPTED ANSWER

      Re: DB2 8.2 Runtime Client ODBC connection to Derby 10.5.3.0

      ‏2010-06-17T16:58:17Z  in response to joachim.stumpf@de.ibm.com
      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.