Skip to main content
T
tonysteve
Participating Frequently
October 13, 2008
Question

simple ques (data sources)

  • October 13, 2008
  • 1 reply
  • 396 views
I'm trying to set up a DATA source of a 2007 MS Acces file called ques.accdb but I keep getting this message:

Connection verification failed for data source: ques
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

The Access file is located in the wwwroot folder and I'm on Windows Vista.
Thanks so much,
Steve
This topic has been closed for replies.

1 reply

-
-__cfSearching__-
Inspiring
October 13, 2008
I do not use Access, but a quick google turned up this link:
http://blog.crankybit.com/msaccess2007-and-cf8/

"... please note that the drivers that come with CF8 do not support Access 2007. This is mentioned in the ColdFusion 8 Release Notes under #69495. The solution is nicely described right in the release notes. Download and install the Data Connectivity Components for Office 2007, set up a Windows ODBC connection, and use ColdFusion’s ODBC socket driver to connect to the Windows ODBC connection. ..."
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices