[dolphinzz]

I use query string

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open = "Dsn='iqdb'; " & _
"Driver={INFORMIX 3.81 32 BIT}; " & _
"Host=name; " & _
"Server=sname; " & _
"Service=sqlturbo; " & _
"Protocol=onsoctcp; " & _
"Database=iqdb; " & _
"UID=user; " & _
"PWD=password"

connect to informix But It's not work.
This is Error Message
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I use windows XP
Driver Informix 3.81 32 BIT
Who has problem like me or know something to correct it plz tell me.
(This Driver download form www.ibm.com)

I Think I use the wrong query string that not support this driver????
I'm not sure.
Or I must change driver??????......where I can download????

Thank for your help!!

[macca]

In order for this connection to work you must have already set up a DSN called "iqdb" on your XP machine. Once you've done this correctly then you only need to quote the DSN name in your connection string as follows:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open = "Dsn=iqdb"

It's as simple as that.

Good luck.