IBM IDS Data Provider Problems

I am extremely new to Informix so forgive me if this is obvious. I installed the developer edition of Informix Dynamic Server on a Windows 2003 R2 Server. I just went through the standard install. I want to use the IBM IDS Data Provider for .NET Framework. This comes with the 9.5 Data Server Client fix pack 1. Although I have tried various versions from the Client SDK to the DB2 Client tools. I am using Visual Studio 2008 and I follow the instructions on the client fix pack install and accept the defaults (apart from giving the files and registry keys specific permissions). I then install the tools for Visual Studio 2008. I assume pretty standard so far. I then go to Server Explorer and Click "Connect to Database", I then get the following 2 extra options for data source IBM DB2, IDS and U2 Servers IBM IDS Server I select the IBM IDS Server (although the other one doesn't work either), and then go to the next page. From here I enter the server name as the name of the machine I have Informix installed on, the informix user and password and tell it to save the details. I enter the name of a database that I know exists on the server and click Test Connection. I get the following error message -------------------------------------------------------------------------------- Microsoft Visual Studio -------------------------------------------------------------------------------- ERROR 08001 IBM 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.118". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "", "". SQLSTATE=08001 -------------------------------------------------------------------------------- OK -------------------------------------------------------------------------------- 192.168.1.118 is the ip of the machine I have informix on. The machine is called raven and I have the following in my services file svc_raven 9088/tcp #ol_svr_raven svc_drda 9089/tcp #svc_drda Now I have DB2 installed on a similar machine and the above works perfectly for DB2 with absolutely no issues. Any help or advice as to why this doesn't work with Informix would be greatly appreciated as I am really keen to use it. Additionally if I install the ODBC driver for Informix from the client SDK then it connects no problem. Thanks in advance Colin

To connect to Informix using "9.5 Data Server Client" you need to use DRDA port number instead of SQLI. As you mentioned "svc_drda 9089" ... so typically this is how connection string would look like while using "9.5 Data Server Client". Accordingly you have to map the same to GUI part of VS 2005/2008. "Server=<server host name>:<drda port>;UID=informix;PWD=xxx;Database=my_db;" So in your case this is how it would look like. "Server=192.168.1.118:9089;UID=xxxx;PWD=xxx;Database=xxx;" HTH -Shesh Colin <colin.paterson@gmail.com> Sent by: informix-list-bounces@iiug.org 18/08/2008 15:29 To informix-list@iiug.org cc Subject IBM IDS Data Provider Problems I am extremely new to Informix so forgive me if this is obvious. I installed the developer edition of Informix Dynamic Server on a Windows 2003 R2 Server. I just went through the standard install. I want to use the IBM IDS Data Provider for .NET Framework. This comes with the 9.5 Data Server Client fix pack 1. Although I have tried various versions from the Client SDK to the DB2 Client tools. I am using Visual Studio 2008 and I follow the instructions on the client fix pack install and accept the defaults (apart from giving the files and registry keys specific permissions). I then install the tools for Visual Studio 2008. I assume pretty standard so far. I then go to Server Explorer and Click "Connect to Database", I then get the following 2 extra options for data source IBM DB2, IDS and U2 Servers IBM IDS Server I select the IBM IDS Server (although the other one doesn't work either), and then go to the next page. From here I enter the server name as the name of the machine I have Informix installed on, the informix user and password and tell it to save the details. I enter the name of a database that I know exists on the server and click Test Connection. I get the following error message -------------------------------------------------------------------------------- Microsoft Visual Studio -------------------------------------------------------------------------------- ERROR 08001 IBM 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.118". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "", "". SQLSTATE=08001 -------------------------------------------------------------------------------- OK -------------------------------------------------------------------------------- 192.168.1.118 is the ip of the machine I have informix on. The machine is called raven and I have the following in my services file svc_raven 9088/tcp #ol_svr_raven svc_drda 9089/tcp #svc_drda Now I have DB2 installed on a similar machine and the above works perfectly for DB2 with absolutely no issues. Any help or advice as to why this doesn't work with Informix would be greatly appreciated as I am really keen to use it. Additionally if I install the ODBC driver for Informix from the client SDK then it connects no problem. Thanks in advance Colin _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

Colin said: > I am extremely new to Informix so forgive me if this is obvious. I I, on the other hand, haven't a clue about .NET. However, I am surprised that at no point in the Informix connection process you refer to the "INFORMIXSERVER" or equivalent. Have you set up a setnet32 connection? -- Bye now, Obnoxio http://obotheclown.blogspot.com/

Specifying the port worked fine. Although I now get 2 further strange errors using Add Connection from the server explorer in Visual Studio --------------------------- Error occurred --------------------------- Error occurred adding the connection. Ensure that your database is started. --------------------------- OK --------------------------- --------------------------- Server Explorer --------------------------- Unable to add data connection. Object reference not set to an instance of an object. --------------------------- OK ---------------------------

Could you post Visual Studio , CSDK and IDS versions? >From the below error it appears that IDS is not up and running and/OR database is not created. Are you able to access the database using "dbaccess" using the same user? If you could provide steps which leads to below errors would help. -Shesh Colin <colin.paterson@gmail.com> Sent by: informix-list-bounces@iiug.org 19/08/2008 00:14 To informix-list@iiug.org cc Subject Re: IBM IDS Data Provider Problems Specifying the port worked fine. Although I now get 2 further strange errors using Add Connection from the server explorer in Visual Studio --------------------------- Error occurred --------------------------- Error occurred adding the connection. Ensure that your database is started. --------------------------- OK --------------------------- --------------------------- Server Explorer --------------------------- Unable to add data connection. Object reference not set to an instance of an object. --------------------------- OK --------------------------- _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list