If column 4 is a name and you're on Unix or Linux, then search for the port name in /etc/services on your Unix or Linux server. Column 4 is the port number or name (Service name in setnet32.exe).Column 3 is the host name (HostName in setnet32.exe).Column 2 is the protocol name (Protocolname in setnet32.exe).Column 1 is the name of the INFORMIXSERVER or an alias (IBM Informix Server in setnet32.exe).The last two lines are the guts of the file. This is my sqlhosts file on a Docker I'm testing: $ cat $INFORMIXDIR/etc/sqlhosts This should give you a file with potentially a bunch of information, you're looking for lines that are not comments and have at least 4 columns. If you're on Windows, then login to the Windows server and from a command prompt, run TYPE %INFORMIXDIR%\etc\sqlhosts
The first question to ask is: is your database running on Unix or Linux? If it is, then by logging in to the database server as user "informix" and running the command cat $INFORMIXDIR/etc/sqlhosts Setnet32.exe will not know the information you are looking for, you need to provide this information to setnet32.exe. This is a very, very difficult question to answer blind. It would be really helpful if anyone can help me. To find values of above fields, i tried looking for SQLHOSTS key in registry entries under HKEY_LOCAL_MACHINE\SOFTWARE\INFORMIX\ unfortunately it wasn't there! and also tried running setnet32.exe from client sdk's bin folder and i could see below screen with only protocol info!. net provider mentioned in above link but no use, i am also having difficulty in understanding from where to get values for each connection string fields like protocol, port, host-name, server-name and service name.
I assume this error is due to connection string field not been supplied properly, i referred and tried using connection string like informix with ODBC driver and informix. When i run a test application, i am getting below error while trying to opening up an connection,ĮRROR System error occurred
In my code i have a reference to which is referred from installed path of Informix client sdk's bin folder netf40. After that i wrote a piece of code referring from here and here.
So far what i did is, i installed Informix client sdk v4.10 in my machine. net using c# to connect to IBM's Informix database.
0 kommentar(er)
