Hello experts,

I am trying to write a simple code to establish a connection
using DSN based ODBC client connection to Unix based Informix
Database.

============================Start Code=============================
Set objConnInformixServer = Server.CreateObject("ADODB.Connection")

objConnInformixServer.ConnectionString = "Dsn=ICacheDB;Driver={INFORMIX 3.82 32 BIT};Host=IP Address;Server=ServerName;Service=1525;Protocol=se soctcp;Database=DatabaseName;UID=Uname;PWD=Passwor d"

objConnInformixServer.Open

Set objCustomerRs = Server.CreateObject("ADODB.RECORDSET")

strQry ="Select * from Pinlist where pinlistref = 143"

objCustomerRs.Open strQry, objConnInformixServer

if not (objCustomerRs.EOF or objCustomerRs.BOF) Then
     pinListRef = objCustomerRs("pinlistref")
     pinListName = objCustomerRs("pinlistname")
end if

Response.Write("<br>PinListRef: " + pinListRef)
Response.Write("<br>PinListName: " + pinListName)
======================End Code=================================
The error i am getting is

"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

Please help me

KG


KG

__________________
KG