ColdFusion MX uses JDBC, not ODBC. Want to use your ODBC data sources with CFMX? You can. Here’s what you need to do: 1) Create the ODBC data source (using Windows Control Panel), and 2) add a data source in ColdFusion MX Administrator of type “ODBC Socket” specifying the name of the ODBC data source. (Applies to: ColdFusion MX)
Using ODBC Data Sources in ColdFusion MX
One response to “Using ODBC Data Sources in ColdFusion MX”
-
I’m having a similar problem and I am unable to resolve it. I downloaded the 0321125169_ows zip file and extracted it. I am using Winn NT 4.0 workstation with ColdFusion MX 6.1.
I added the System DSN for the OWS Microsoft Access Database (directory path is correct, double-checked to make sure the OWS.mdb was fully selected). Then, when I try to add the OWS data source with the Microsoft Access Driver selection, I receive the following error:
Connection verification failed for data source: ows
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access 97 Driver] Can’t open database ‘(unknown)’. It may not be a database that your application recognizes, or the file may be corrupt.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access 97 Driver] Can’t open database ‘(unknown)’. It may not be a database that your application recognizes, or the file may be corrupt.
Please note that I followed your posted instructions and successfully added the CompassTravel.mdb as a data source.
Thanks in advance!!!
Leave a Reply