Skip to main content
Participant
October 30, 2009
Question

How to connect to Caché database?

  • October 30, 2009
  • 1 reply
  • 701 views

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

This topic has been closed for replies.

1 reply

ilssac
Inspiring
October 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.

Participant
November 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