Estebann Aristizabal S
Estebann Aristizabal S

Reputation: 668

Connecting Informix database with .NET Provider

I tested with testconn40 and it gives me these errors. I uninstalled and installed it again and the error persists. I disabled my firewall. I'm using a local server. In the documentation it says is:

SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP".
Communication API being used: "SOCKETS".
Location where the error was detected: "192.168.1.200".
Communication function detecting the error: "recv".
Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001

*,*,0 indicates the connection was closed by the peer. This could be any network device (i.e. firewall, router, workload balancing device, etc...) between the client and DB2 server, or the DB2 server itself.

enter image description here

Upvotes: 4

Views: 1857

Answers (1)

Estebann Aristizabal S
Estebann Aristizabal S

Reputation: 668

I tested with Informix Server 12.10 Enterprise Trial Edition, I downloaded the last fix pack https://www-01.ibm.com/support/docview.wss?uid=swg24043166 download only the IBM DATA SERVER CLIENT for your OS, I try for the 32bits. Be sure to enable DRDA support in the installer and save the ports that it will use.

  1. In etc/services search which port is using drda in the informix server in my case: dr_informix1210_2 27526/tcp
    1. In the informix directory my case: C:\Program Files\IBM Informix Software Bundle\etc open the sqlhost.informix1210_2 file.
    2. Change dr_informix1210_2 drsoctcp "yourcomputername" dr_informix1210_2 TO THIS dr_informix1210_2 drsoctcp 127.0.0.1 dr_informix1210_2
    3. Restart the server
    4. Run the command netstat -an | findstr 27526
    5. If it says it's listening run the command testconn40 database=pruebas;server=127.0.0.1:27526;userid=informix;password=1234
    6. If it's not listening the DRDA support it's not enabled, try reinstalling the server enabling it in the wizard.
    7. Finally, you can connect to Visual Studio 2015 with the IBM .NET Provider.

Upvotes: 4

Related Questions