informix again

[parames]

thanks James Culshaw for your guide.. anyway, i'm very very new to this informix. so, i really need help from your guys because it is urgent..

now, i knew that we can connect to informix database which resides in another server through odbc connection.. but, i really have no idea how to do that..

as i know, to connect to access database we do something like this..
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("online.mdb&quot
set conn = server.createobject("adodb.connection&quot
conn.open strconn
set rs = server.createobject("adodb.recordset&quot

but, how to do this for informix which is in another server (unix platform)??

please help..
rgds,
parames.s

 

[culshaja]

If informix is anything like Oracle you will need to install the client software onto your IIS Server.
Please bare in mind that what I am about to describe is Oracle but it might illustrate what you need.

1. Install the client software onto the IIS Server.

2. Create a System DSN on your machine using the ODBC driver, and ODBC administrator.

3. In the ConnectionString specify the DSN that was created ins step 2 rather than trying to create a DSN in the ConnectionString.

This should then work fine.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[leonelvr]

man... i hope this helps you....
visit

http://www.scit.wlv.ac.uk/appdocs/chili-asp/html/syntax_for_dsn_less_connection_strings.htm

http://www.able-consulting.com/ADO_Conn.htm

good luck...