I have installed the trial version of IDS 9.4 on a RedHat 9.0 box. The docs were terrible, but I did get it installed and am able to access it locally via DBACCESS as well as the ServerStudioJE tool (both on the same box as IDS). I downloaded the Client SDK from IBM and installed it on my Win2K box. Next I setup a DSN and tried to make an ODBC connection..it failed. I tried to telnet the server at the port I gave the IDS service in etc/services...connection refused. I tried again to telnet, this time locally on the server using localhost...connected no problem.
Many online postings talk about starting the sqlexecd daemon in $INFORMIXDIR/lib/ however I have gone all through the $INFORMIXDIR and found no sqlexecd. Do I need to install something? At this point I only have the trial version of IDS 9.4 installed.
I resolved this issue myself. After posting this question I ran netstat and noticed that the IDS server was listening on the correct port, but on the loopback address (127.0.0.1), so I changed this by putting the servers IP address is the sqlhosts file and restarting the IDS server. I am able to connect through the IBM ODBC drivers that come w/ the Informix Client SDK.