How to connect to Informix database using ADO???
I'm using ADO sucsesfully with Oracle 8 and 9. For the Excels I use to be able to query the Oracle DB, the workstation must have the Oracle client software installed and the database defined in the tnsnames.ora
As for Informix, I'm sorry, but I don't know what kind of client software has to be installed on the workstation, but there definitely has to be something more or less like for Oracle
ADO has to work with an OLEDB Provider for the specific database (for me it is MSDAORA.1), plus, there might be needed some other software on the client to connect to the database ..
I suggest you should ask this in an Informix forum.
|