Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Informix ODBC Connection String

Status
Not open for further replies.

TrevorMoore

Programmer
Nov 5, 2002
1
US
I'm trying to use the IBM Informix UniVerse ODBC Driver to connect to the Informix server via ASP, and I cannot figure out the connection string. Can anyone give me a hand?

Here's what I have. Please note that the MySQL Connection works perfectly.

Here’s the error I get:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Ardent][UVODBC][0301892]Error ID: 108 Severity: SEVERE Facility: LINKERR - Connection refused

Here’s the ASP code I’m using:
<%
'---------------------------------------------
'- Database Library Functions - Include File -
'---------------------------------------------

' Global Variables and Constants
dim DSN_admin, DSN_informix

DSN_admin = &quot;driver={MySQL};server=localhost;uid=admin;password=XXXXXXXX;database=tlg&quot;

DSN_informix = &quot;driver={Informix UniVerse ODBC Driver};server=xxx.xxx.xxx.xxx;uid=xxxxxxxx;pwd=XXXXXXXX;database=mb&quot;

Sub G_OpenRecordset(objRS, objDSN, strSQL)
set objRS = Server.CreateObject(&quot;ADODB.Recordset&quot;)
objRS.ActiveConnection = objDSN
objRS.Source = strSQL
objRS.Open()
End Sub

sub G_ExecRecordset(objDSN, strSQL)
Dim objCon
set objCon = Server.CreateObject(&quot;ADODB.Connection&quot;)
objCon.open objDSN
objCon.execute strSQL
objCon.close
End Sub
%>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top