I'm trying to connect to an Access 2000 database on our network. The file is on a file server in the same domain as our Intranet. I have the ColdFusion MX app server logging in as my own domain account, which has full access to the database. Connecting to local databases works fine. The database has no security on it- it can open for anybody. I'm using the Microsoft Access driver provided with ColdFusion MX. I'm running CFMX Updater 3. However, ColdFusion is giving me the following error when verifying the database, and it is happening for all network Access databases:
Connection verification failed for data source: trymp []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
