Thanks for the reply Bryan. I tried compacting/repairing- same result. Interestingly, I've noticed the same erratic behavior on more than one Access database- both 97 and 2000. It's extremely odd. I've also thought about adding an ODBC connection to the database and going at it that way, but I noticed when I tried to create an ODBC connection it wants me to map the drive first- I can't just put in the full URL, which is not an option on this server. Anybody know if there's a way around this, or have another suggestion? Or, does anybody know if there's another way to add data sources other than the CF Administrator (which I really suspect may be my problem- as I've seen other bugs with it as well).
Thanks, Kevin -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 4:47 PM To: CF-Talk Subject: Re: Very odd behavior with data sources. please help if you can 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
