wmjie / ibm-db

Automatically exported from code.google.com/p/ibm-db
0 stars 0 forks source link

"An unexpected system error occurred." while connecting to informix 11.70FC7 #135

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.Start python interpreter
2.import ibm_db
3.conn = ibm_db.connect( 
"DATABASE=actoren;HOSTNAME=vbxl051.development.vaph.be;PORT=9502;PROTOCOL=TCPIP;
UID=informix;PWD=kaka;",'','');
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
Exception: [IBM][CLI Driver] SQL1042C  An unexpected system error occurred.  
SQLSTATE=58004 SQLCODE=-1042

What is the expected output? What do you see instead?
Connect should return a connection object.

What version of the product are you using? On what operating system?
ibm_db version 2.0.4
Linux vbxl011 3.2.0-4-amd64 #1 SMP Debian 3.2.46-1+deb7u1 x86_64 GNU/Linux
IBM Informix Dynamic Server Version 11.70.FC7IE
ibm_data_server_driver_package_linuxx64_v10.5

Please provide any additional information below.
(part of) sqlhosts file on the server :
ifxolympustest_dr drsoctcp vbxl051 9502

The IE version of informix is used as a test machine before using the driver on 
our production machine ( running the full version ).

Original issue reported on code.google.com by peter.va...@gmail.com on 19 Sep 2013 at 12:44

GoogleCodeExporter commented 9 years ago
Please go through 
http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.mess
ages.sql.doc/doc/msql01042c.html to resolve your problem 

Original comment by rahul.pr...@in.ibm.com on 23 Sep 2013 at 7:15

GoogleCodeExporter commented 9 years ago
Hi, the problem is resolved. Ibm_db requires gskit on the serverside and the 
installer does not do a good job on a debian machine. I crafted deb packages 
for it and now connections work perfectly. Sorry for the noise.

Original comment by peter.va...@gmail.com on 23 Sep 2013 at 2:27

GoogleCodeExporter commented 9 years ago

Original comment by rahul.pr...@in.ibm.com on 18 Nov 2013 at 5:58