How to connect to Caché database?

Report · Oct 30, 2009

I successfully created an ODBC connection in Windows to a distant Caché database.

How should I proceed to create a CF datasource for this database ?

Thanks

Report · Oct 30, 2009

You could use the ColdFusion "ODBC" jdbc-odbc bridge database driver to connect to the ODBC connection you have defined in Windows.

If this is a JDBC, or you can find a JDBC, driver for this databse you can use the 'Other' database type to define the specifics of any available JDBC database driver.

Report · Nov 16, 2009

Hi Ian,

I followed your advice and tried to create a datasource under CF admi using the ODBC Socket driver but I always get the error

"The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed."

Is it a question of tweeking my connection string ?

Could it be that I can't connect with that Caché database with the Windows ODBC driver provided ?

I'm clueless

Thanks