Problem with .net provider for Informix
Posted in 2004
Hi every one, can someone try to help us with this issue? we are trying to use the new .net provider for Informix. We are having big problems to get it to work. We are able to send one or two calls but then we get all kind of error messages and it often ends with that Informix on the server stops! We try to use the pooling function for connections. Even if we set "Min Pool Size=20;Max Pool Size=100;Pooling='true';" on the server side we can see that we got 200!!! connections and when we run more calls we get 20 more !! But none of them seems to run any SQL on the server. Can't find much information in the Reference Guide about pool connection handling ? Where can we find more information about how the pool works ? oex.Message=No error information available: DB_E_ERRORSINCOMMAND(0x80040E14). Error: EIX000: (-11020) Communication link failure.: A protocol error has been detected. Current connection is closed. Error: No error information available: 0xFFFFFFFF. oex.Message=No error information available: E_FAIL(0x80004005). Hope that we can get some tip on what the problem is or if we are doing something wrong ? On the server we are running Informix 9.4_UC2 on Solaris 8. On the Client we are running SDK v2.81 TC3 and .Net Framework version 1.1 and we try start up to a number of connections to the Informix server. We even installed the .net Framework after the new SDK but it still don't work. Best regards Jimmy The connection string looks like this: "Host=Aron.infodata.se;Service=1502;Server=svkyrktcp_aron;User ID=abcde;Password=???????;Database=systestdb;" The setting in setnet32 is: ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÅ ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖEnvironmentÅ "INFORMIXDIR"="C:ÖÖProgram FilesÖÖInformixÖÖClient-SDKÖÖ" "CONRETRY"="10" "CONTIME"="3" ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖESQL/CÅ "INFORMIX-Connect"="9.00.TC1" ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖInformix ORDBMSÅ ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖInformix ORDBMSÖ1.0Å ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖInformix-ConnectÅ ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖInformix-ConnectÖ9.00TC1Å ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖInformix-ConnectÖ9.00TC1ÖSetupÅ "SoftwareType"="RDBMS" ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖnetrcÅ "PROTOCOLLIST"="olsoctcp;onsoctcp;olsocspx;onsocspx;sesoctcp;sesocspx;seipc i p;olipcnmp;onipcnmp" ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖSetupÅ ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖSetupÖCurrent VersionÅ "Registered Organization"="SchlumbergerSema InfoData AB" "Registered User"="infoprod" ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖSetupÖInstalledDirectoriesÅ "C:ÖÖProgram FilesÖÖInformixÖÖClient-SDKÖÖ"="2004-03-16" ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖSqlHostsÅ ÄHKEY_LOCAL_MACHINEÖSOFTWAREÖInformixÖSqlHostsÖsvkyrktcp_aronÅ "HOST"="aron.infodata.se" "SERVICE"="1502" "PROTOCOL"="olsoctcp"