Try this:
http://www.forta.com/cf/tips/index.cfm?age=169
==
Peter Tilbrook
Internet Applications Developer
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2601
AUSTRALIA
WWW: http://www.abcb.gov.au/
E-Mail: [EMAIL PROTECTED]
Telephone: +61 (02) 6213 6731
Mobile: 0439 401 823
Facsimile: +61 (02) 6213 7287
-----Original Message-----
From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 March 2003 9:55 AM
To: CF-Talk
Subject: Problem with Access database connection
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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
