Informix 11 Drivers

[Diacritical]

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?

[StevenErat]

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.

[MeinMe2003]

Hi There,

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

[Newsgroup_User]

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

[MeinMe2003]

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?

[Newsgroup_User]

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

[MeinMe2003]

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

All the best...

MeInMe2003