Informix 11 Drivers

Report · Jul 28, 2007

We're moving to Informix 11 and find that the Informix support in MX 7 can't quite make it work ("end of stream" errors). The JDBC drivers that come with Informix seem OK, but I would rather not redo all our datasources for a new driver.

Any word on when there will be a patch if it is not there yet?

Report · Jul 31, 2007

Informix 11 is not supported in the current driver version of CF8. It may be some time before ColdFusion provides a driver version with support for that DB version, probably not in the near future.

Report · May 12, 2008

Hi There,

Any idea when Cold Fusion MX7 will have native database drivers that support Informix IDS 11.1?

Report · May 16, 2008

MeinMe2003 wrote:
> Any idea when Cold Fusion MX7 will have native database drivers that support Informix IDS 11.1?

CF 7 is no longer developed, CF 8 is out already so I guess the earliest
possible moment would be the release of CF 9. And even then there is no
guarantee it will have support for Informix 11.

Why not ask your database vendor for JDBC drivers?

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion

Report · May 23, 2008

Jochem,

Thanks for your reply.

Currently, we are able to use CF 7 and IDS 11.1 via ODBC.
Are you aware of the advantages and disadvantages when comparing ODBC to JDBC?

Report · May 27, 2008

MeinMe2003 wrote:
> Currently, we are able to use CF 7 and IDS 11.1 via ODBC.
> Are you aware of the advantages and disadvantages when comparing ODBC to JDBC?

<quote>
JDBC-ODBC bridge

Translates JDBC calls to ODBC calls, and sends them to the ODBC driver.

Advantages Allows access to many different databases.

Disadvantages The ODBC driver, and possibly the client database
libraries, must reside on the ColdFusion server computer. Performance is
slower than other JDBC driver types.

Adobe does not recommend this driver type unless your application
requires DBMS-specific features.
</quote>
http://livedocs.adobe.com/coldfusion/8/htmldocs/datasources_ADV_MJS_02.html#1261469

--
Jochem van Dieten
Adobe Community Expert for ColdFusion

Report · May 27, 2008

Jochem,
Many thanks for your time, effort and sharing of gray matter.

All the best...

MeInMe2003