database alias or database name [] was not found

[Ralf Kelzenberg]

I compiled ibm_db 2.0.2 from source using the dsdriver package 10.1fix2

I have LD_LIBRARY_PATH set to the odbc_cli lib

I try to connect to an informix 12 database

 

when I do:

 

ibm_db_conn = ibm_db.connect(";DATABASE=NAME;HOSTNAME=XXXXXXXX;PORT=XXXXXX;PROTOCOL=TCPIP;UID=XXXXX;PWD=XXXXXX;", "", "")

 

I get:

 

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
Exception: [IBM][CLI Driver] SQL30061N  The database alias or database name "NAME    " was not found at the remote node.  SQLSTATE=08004 SQLCODE=-30061

All values where checked multiple times and should be ok.

 

I am aware of issue:

 

http://code.google.com/p/ibm-db/issues/detail?id=88

 

but not a single how-to or the description on the installation procedure here:

 

http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/index.jsp?topic=%2Fcom.ibm.swg.im.dbclient.python.doc%2Fdoc%2Ft0054367.html

 

mentions anything about a license.

 

Is the answer from isse 88 (you need a license file) also true for the informix case? If yes, why is it mentioned nowhere? Are there any other workarounds?

 

Thanks in advance

 

Ralf Kelzenberg

[Praveen]

Hi Ralf,

You will not need a license to connect to informix server, license is need only for connecting to DB2 on zOS and DB2 on IBMi.

The error here complains the database name specified does not exist on the server. Could you ensure you are specifying the correct database name. Also ensure you are connecting via the DRDA port on informix server.

Thanks

Praveen

[Ralf Kelzenberg]

Hi Paveen.

Thanks for the hint. My error was to mistake the database name for the server name. You actually have to give the name of the database in the connection string instead the database instance server name that you give for example in jdbc connection.

Cheers,