Skip to main content
T
tonysteve
Participating Frequently
June 8, 2008
Question

database doesn't show up when I add it

  • June 8, 2008
  • 1 reply
  • 588 views
I am adding a MS access '07 database that I made, but when I go to add it and browse to it, it does not show up..Is there a reason why it is not showing up. I also get this message when I try to verify it:

Connection verification failed for data source: ask
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)'.

help!!
This topic has been closed for replies.

1 reply

P
paross1
Participating Frequently
June 9, 2008
Where is your Access db file located in relation to your ColdFusion server (wwwroot)? This is telling you that CF can't find the database file, and it must be located where CF has access and the appropriate permissions.

Phil
A
Anonymous
June 9, 2008
You must install the MS Access 2007 driver on your system. ColdFusion does not do this for you. You then need to create an ODBC system dsn using window's odbc manager. Then create an ODBC socket DSN in coldfusion to use your database. See this forum thread for more info.
T
tonysteveAuthor
Participating Frequently
June 15, 2008
When I place another access file ( one which I downloaded off the web) in the wwwroot folder, it does show up.

For some reason some access files show up and others do not...Is this strange?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices