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

x
?
Solved

Informix connection string

Posted on 2004-11-08
3
Medium Priority
?
903 Views
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 : 1.12.12.34
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)
0
Comment
Question by:showbix
2 Comments
 

Accepted Solution

by:
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
0
 
LVL 4

Assisted Solution

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

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