Just a shot in the dark, but try compacting and repairing the DB in question. I've had Access DB's get locked like that before and that solved it (damn things corrupt at a drop of a hat).
Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Ruggiero, Kevin D" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 26, 2003 1:40 PM Subject: Very odd behavior with data sources. please help if you can > I am getting the following error: > > BEGIN ERROR: > Connection verification failed for data source: stdparts > []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. > END ERROR. > > This is happening within ColdFusion Administrator (CF MX). What is so > strange is that this problem occurs sometimes, and not other times. In > other words, I can setup a datasource to a network Access database, and it > will work fine. I can then try to setup the exact same data source on the > production machine, and it will get the error above. EVEN STRANGER is that > I can then go back to my original data source that worked fine, modify it > trivially (change the data source name), and I will begin getting the > message above. Setting up these datasources works sporadically, with a > tendency towards not working at all. The account ColdFusion is running as > has full control to the file and share. > > Can anybody please shed light on why this is happening? I'm finding it to > be a problem on my test machine AND my production machine. Is there any > other way to setup data sources other than through the CF Administrator? > > Thanks. > > Kevin Ruggiero > Northrop Grumman Amherst Systems > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
