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
