• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Problems connecting to MS Access database

New Here ,
May 15, 2012 May 15, 2012

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

TOPICS
Database access

Views

4.8K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Sep 05, 2012 Sep 05, 2012

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?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Sep 05, 2012 Sep 05, 2012

Copy link to clipboard

Copied

LATEST

http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess

Perhaps try reference for solution.

HTH, Carl.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation