How to define port number with DB2 ODBC driver?

How to define port number with DB2 ODBC driver?

am 02.10.2006 13:59:48 von Martin.Evans

Hi,

I'm using DB2 8.2 on Linux and have downloaded and installed the DB2 ODBC
driver which is installed under unxiODBC. I have defined a data source to
connect to the local db2 but when I try to connect I get:

[08004][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure.
comm rc=10061 - CWBCO1049 - The iSeries server application is not started

When I strace this is shows a connect to port 8471 but I believe my server is
listening on port 50000. From the /etc/services file:

db2c_db2inst1 50000/tcp

A netstat also shows listen on 50000. How do you tell the DB2 ODBC driver or
client libraries to use port 50000?

Martin

--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com

Re: How to define port number with DB2 ODBC driver?

am 02.10.2006 17:02:08 von Tim.Bunce

Perhaps http://www.connectionstrings.com/ can help.

Tim.

On Mon, Oct 02, 2006 at 12:59:48PM +0100, Martin J. Evans wrote:
> Hi,
>
> I'm using DB2 8.2 on Linux and have downloaded and installed the DB2 ODBC
> driver which is installed under unxiODBC. I have defined a data source to
> connect to the local db2 but when I try to connect I get:
>
> [08004][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure.
> comm rc=10061 - CWBCO1049 - The iSeries server application is not started
>
> When I strace this is shows a connect to port 8471 but I believe my server is
> listening on port 50000. From the /etc/services file:
>
> db2c_db2inst1 50000/tcp
>
> A netstat also shows listen on 50000. How do you tell the DB2 ODBC driver or
> client libraries to use port 50000?
>
> Martin
>
> --
> Martin J. Evans
> Easysoft Ltd, UK
> http://www.easysoft.com
>