- For individual users
- Instant access to solutions
- Ask your tech questions
- Start your 30-day Free Trial
Main Topics
Browse All TopicsI have setup a test Informix DB Server (v11.x) on Windows 2008 Server and can connect to it via AGS Server Studio on the local box (Server 2008), but not through ODBC. This is my first time working with Informix so I am not entirely clear on the setup procedure to enable ODBC and/or remote connections. Any help is greatly appreciated and the fast-the-better!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: flutophilusPosted on 2009-10-27 at 03:11:04ID: 25670655
You'll need a copy of the Informix Client Software Development Kit (CSDK) for the the client computer. It's a free download from the ibm website.
com/infoce nter/idshe lp/v10/ ind ex.jsp?top ic=/com.ib m.sqlr.doc /sqlrmst23 0.htm
m/CSDK_Art icle/CSDK_ Article.pd f
You then need to configure it using the setnet program that comes with the CSDK. In there you define the host, the server name (i.e. the name of the Informix instance on the host (which must be defined in the host sqlhosts file), connection protocol (typically onsoctcp or olsoctcp - the same thing) and the service that the host is accepting comms on (i.e. the port number, also defined in the hosts sqlhosts file).
Take a look at this first
http://publib.boulder.ibm.
it gives the full background to setting up the sqlhosts file on Unix servers. If you running the CSDK on Windows you configure sqlhosts data (which is in the registry) using the setnet utility that comes with it, but unless you understand the concepts of sqlhosts you'll struggle.
Here's an excellent intro to the CSDK
http://www.questinfosys.co
hth