How to connect to the DB2 on a REMOTE machine from a C++ application on Linux?

[mjf]

I'd like to connect from any Linux machine to the DB2 on a Linux server
via an IP adddress (or any available method that allows us to connect
to DB2 from another machine). I know we can do it in Java via JDBC in
the following fashion (suppose my IP address is xx.x.x.xxx):

sun.jdbc.odbc.J dbcOdbcDriver=c om.ibm.db2.jcc. DB2Driver
sun.jdbc.odbc.C onnectionUrl=jd bc:db2://xx.x.x.xxx:5000 0/mydb
sun.jdbc.odbc.U serId=db2inst1
sun.jdbc.odbc.P assword=mypassw d

Is there a similar way for an application in C++ on Linux? Currently
the application has to be on the same machine as the DB2 server.

I'm using DB2 UDB Express Edition V8.2 for Linux.

Thanks.

[Knut Stolze]

mjf wrote:

I'd like to connect from any Linux machine to the DB2 on a Linux server
via an IP adddress (or any available method that allows us to connect
to DB2 from another machine). I know we can do it in Java via JDBC in
the following fashion (suppose my IP address is xx.x.x.xxx):

sun.jdbc.odbc.J dbcOdbcDriver=c om.ibm.db2.jcc. DB2Driver
sun.jdbc.odbc.C onnectionUrl=jd bc:db2://xx.x.x.xxx:5000 0/mydb
sun.jdbc.odbc.U serId=db2inst1
sun.jdbc.odbc.P assword=mypassw d

Is there a similar way for an application in C++ on Linux? Currently
the application has to be on the same machine as the DB2 server.

Install a DB2 client on the, well, client. Then you catalog the database on
the server at your client and go ahead happily accessing the database as if
it were a local one.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[mjf]

Hi Knut, thanks for the timely info! Is that the only way?

[Dan Scott]

You always have to have a DB2 client installed on the client machine.
However, (and this is a little known tidbit of information) you can
skip the "catalog the database on the server at your client" step by
using a direct TCP/IP connection string with the SQLDriverConnec t()
API. We made use of this option to the ibm_db2 extension in PHP to
enable you to connect to arbitrary DB2 databases on any machine
(assuming you have the user ID and password).

/* Substitute database, hostname, port number, user ID, and password
values */
SQLCHAR *conn = "DRIVER={IB M DB2 ODBC
DRIVER};DATABAS E=myDb;HOSTNAME =hostname;PORT= 50000;PROTOCOL= TCPIP;UID=db2in st1;PWD=passwor d;";

rc = SQLDriverConnec t((SQLHDBC)conn _res->hdbc, (SQLHWND)NULL,
conn, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPR OMPT );

Dan

[mjf]

Dan Scott wrote:

You always have to have a DB2 client installed on the client machine.
However, (and this is a little known tidbit of information) you can
skip the "catalog the database on the server at your client" step by
using a direct TCP/IP connection string with the SQLDriverConnec t()
API. We made use of this option to the ibm_db2 extension in PHP to
enable you to connect to arbitrary DB2 databases on any machine
(assuming you have the user ID and password).

/* Substitute database, hostname, port number, user ID, and password
values */
SQLCHAR *conn = "DRIVER={IB M DB2 ODBC
DRIVER};DATABAS E=myDb;HOSTNAME =hostname;PORT= 50000;PROTOCOL= TCPIP;UID=db2in st1;PWD=passwor d;";

rc = SQLDriverConnec t((SQLHDBC)conn _res->hdbc, (SQLHWND)NULL,
conn, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPR OMPT );

Dan

Dan, thanks!!

[Jan M. Nelken]

Dan Scott wrote:

You always have to have a DB2 client installed on the client machine.
However, (and this is a little known tidbit of information) you can
skip the "catalog the database on the server at your client" step by
using a direct TCP/IP connection string with the SQLDriverConnec t()
API.

Please keep in mind that in V8 there is no AUTHENTICATION= keyword in
SQLDriverConnec t() connection string.
Consequently - for DSN-less connections AUTHENTICATION= CLIENT is assumed causing
- on Windows - a trip to domain controller and possible slowdown before
shipping connection to remote server.

Jan M. Nelken