Problems connecting to MS Access database

Question

HiI'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: databasejava.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

VincentL12 · Answer

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?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded