Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


ODBC Connectivity problems

ODBC Connectivity problems

ODBC Connectivity problems

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.



RE: ODBC Connectivity problems

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??

RE: ODBC Connectivity problems

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

forget DNS and hosts - use numbers

RE: ODBC Connectivity problems

what do you mean bare number?

RE: ODBC Connectivity problems

 1528 for service
 and for address


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close