Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Informix connection string

Posted on 2004-11-08
Medium Priority
Last Modified: 2008-01-09
I have created an ODBC connection for Informix using IBM INFORMIX 3.82 32 BIT driver
Below is the ODBC details.

Data Source Name : abc_x
Server Name : abc_x
Host Name :
Service : abc_s
Protocol : onsoctcp
Database Name : abc
User ID : user1
Password : pwd1

How does my connection string look like below?

Set objConn = server.createobject("Adodb.Connection")
objConn.Open <Connection String>
strSQL = "select top 100 * from table1"
Set rs = objConn.Execute(strSQL)
Question by:showbix

Accepted Solution

Lc001tr earned 150 total points
ID: 12525369
"Dsn='';Driver={INFORMIX 3.82 32 BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd

Assisted Solution

boriskalavsky earned 150 total points
ID: 12526220
strConn = "Driver={Informix}; Server=[server_name];
Database=[database_name]; UID=[username]; PWD=[password]"

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question