ODBC Connection ASP code for Informix Database
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
|