I think your connection string should look like as follows. However what's
an error you are getting?

Connection.Open = "Provider=MSDASQL;driver={IBM INFORMIX 3.82 32 Bit
};Server=hp570_1;Database=demo;Uid=usrdemo;Pwd=dem o00;"

To get the exact name of the IBM Informix ODBC driver installed in your
system, go to Control Panel->Administrative Tools->Data Sources (ODBC) and
click on "Drivers" tab. There you will see name/string you must be
supplying for the "driver" attribute above in your connection string.

-Shesh




"Marco Garutti" <marco.garutti@tecnoform.com>
Sent by: informix-list-bounces@iiug.org
09/26/2006 12:56 PM
Please respond to
Marco Garutti <marco.garutti@tecnoform.com>


To
informix-list@iiug.org
cc

Subject
Asp connect to Informix






Hello there,
I'm trying to connect ASP pages (working under IIS6) to informix db
(working
in Suse Linux Environment),
using this string:
<%
------------------------
Connection.Open = "driver={Informix-CLI 3.82 (32
Bit)};Server=hp570_1;Database=demo;Uid=usrdemo;Pwd =demo00;"
------------------------
and then
Sql = "SELECT sdpri0, sdpri1, tec_sdpri0, tec_sdpri1 FROM sdpri"
Set Example = Connection.Execute(SQL)
arrView = Example.GetRows
%>

but the Connection.Open string seems not to work
Can anyony help me to find out the solution ?
Any help will be grateful.
Marco Garutti


_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list