Informix ODBC Setup Questions

[gollumullog]

I'm having trouble connecting to a new trial installation of Informix, using the IBM Informix ODBC Driver.

When I try to test my connection it tells me:
Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix]Cannot locate turbo service/tcp service in etc/services.

I have checked the etc/services and it contains the following line:

turbo 1526/tcp #ol_support

My settings in the ODBC setup are:
server name: ol_support
host name: support
Service: turbo
Protocol: onsoctcp
Options:
Database Name: [set to database I just created with no tables]
User Id: ./informix
Password:

similar to this thread:
thread179-714666

Any help greatly appreciated.

 

[mberni]

Hi!

To set up a connection you will have to make sure, that the database server listens on exactly that port you are trying to connect to.

- Check your sqlhosts file for proper setup
- try to ping your server and look if it is reachable

 

[gollumullog]

Looks like I needed to add the following line to the client etc/services file:
turbo 1526/tcp

 

[mberni]

hmm,

you said that you already did so ... so i didn't ask for the obvious