Copy link to clipboard
Copied
Hi
I'm using Coldfusion 9 (with latest patch) developer edition, on Windows 2008 server 32bit. I had Office 2010 installed and created a database using Access (had an .accdb extension). When I try to use the CF administrator to create a datasource, I receive this error message:
Connection verification failed for data source: database
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Cannot 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 Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
I thought it might be because I was using a new version of Access, so I downgraded to office 2007, got same problem.
I've tried googling around for this, there seems to be discussion about this problem on 64bit systems. Can anyone tell me how I could fix this please? its getting frustrating.
thanks
Copy link to clipboard
Copied
I have got ColdFusion 10 loaded and have similar connection problems for Access databases. I am using Office 2010.
There was discussion on other threads here two years ago, and following the recommendations there (setting up the DSNs on \Windows\SysWOW64\odbcad32.exe, etc), I can establish some sort of connection on the CF Administrator. However queries on the datasources all result in the message "Error Executing Database Query". [Macromedia][SequeLink JDBC Driver][SequeLink Server], Unable to retrieve error message from backend ODBC driver.
Anyone any ideas?
Copy link to clipboard
Copied
http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess
Perhaps try reference for solution.
HTH, Carl.