ODBC Connectivity problems

[billthornton]

If anyone can help me with the following i would be very grateful.

I am currently trying to connect to our Informix database. I have set up the connection before on windows 95, 98 and 2000. I am now trying to do the same with XP.

I have installed the Informix Client-SDK 2.70 with ODBC driver 3.80.

I have added sqlexec 1528/tcp to the file c:\windows\system32\drivers\etc\services (for win95 and 98 I have put it into c:\windows\services)

I have added the host into LMHOSTS and can ping it from the command prompt.

I use the setnet32 program and define the DBPATH, INFORMIXDIR, INFORMIXSERVER, then in the Server Informa
tion screen i define the server, hostname, protocolname, service name (as sqlexec) and leave options blank.

Then in host information i enter the user name and password.

All of the above i done exactly as i have before in the other versions of windows.

Next i reboot (i have tried not rebooting aswell), and then go open up ODBC Admin in control panel.

I add a new new one using Informix driver 3.80. I then enter all the information as i have before. click on the drop down database name tab, and i get the error "[INFORMIX][INFORMIX ODBC Driver][Informix] Cannot locate sqlexec service/tcp service in /etc/services".

I have seen this before, when i have installed the ODBC driver before, but this has been due to the services file not having sqlexec in it.

Any help would be much appreciated.

Regards,

Bill

 

[billthornton]

Its ok i have solved the problem.

Who would have thought that you have to leave a blank line at the end of the services file, otherwise the last service is not picked up in Windows??

 

[Guest_imported]

forget c:\winnt\wherever\services in windows
use bare numbers

forget DNS and hosts - use numbers

 

[billthornton]

what do you mean bare number?

 

[Guest_imported]

use
1528 for service
and 1.2.3.4 for address

...