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.JdbcOdbcDriver=com.ibm.db2.jcc.DB2Dr iver
sun.jdbc.odbc.ConnectionUrl=jdbc:db2://xx.x.x.xxx:50000/mydb
sun.jdbc.odbc.UserId=db2inst1
sun.jdbc.odbc.Password=mypasswd

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.JdbcOdbcDriver=com.ibm.db2.jcc.DB2Dr iver
sun.jdbc.odbc.ConnectionUrl=jdbc:db2://xx.x.x.xxx:50000/mydb
sun.jdbc.odbc.UserId=db2inst1
sun.jdbc.odbc.Password=mypasswd

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 SQLDriverConnect()
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={IBM DB2 ODBC
DRIVER};DATABASE=myDb;HOSTNAME=hostname;PORT=50000 ;PROTOCOL=TCPIP;UID=db2inst1;PWD=password;";

rc = SQLDriverConnect((SQLHDBC)conn_res->hdbc, (SQLHWND)NULL,
conn, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT );

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 SQLDriverConnect()
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={IBM DB2 ODBC
DRIVER};DATABASE=myDb;HOSTNAME=hostname;PORT=50000 ;PROTOCOL=TCPIP;UID=db2inst1;PWD=password;";

rc = SQLDriverConnect((SQLHDBC)conn_res->hdbc, (SQLHWND)NULL,
conn, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT );

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 SQLDriverConnect()
API.

Please keep in mind that in V8 there is no AUTHENTICATION= keyword in
SQLDriverConnect() 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