I continue to get this error message when conneting to an Access database: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '\\Denya2619\C-Drive\AccessTest\stdparts.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I have the coldfusion server running as my own account, which has full control access to the share (C-Drive) and the NTFS permissions. There should be no problems opening the MDB. Also, nobody else is in that database. I have now tried creating a local access database and linking to the remote one, and connecting coldfusion to the local one. This makes the datasource create properly, but I get the error above when trying to actually connect to the database. I have also tried creating an ODBC data source to the database, and connecting through that, but that is not working either (exact same error). If I connect directly to the database with the Access driver, I get an error right when I try to add the datasource in CF MX Administrator. Can anyone help me out here? I have no idea what the problem could be at this point. I feel like I've exhausted every possible round-about way to connect to this network database. I've tried it with the database as Access 97 and Access 2000, with compacting/repairing, etc. Are there other JDBC Access drivers that might work instead? Any help is appreciated, thanks. Kevin -----Original Message----- From: Ruggiero, Kevin D Sent: Wednesday, March 26, 2003 6:24 PM To: CF-Talk Subject: RE: Very odd behavior with data sources. please help if you can This is the route I am now exploring- setting these up as ODBC Socket connections in ColdFusion Administrator, and creating ODBC Data sources to the databases. This is my problem though: Can I setup an ODBC data source in Win2k without mapping a drive? When I try to do this through the ODBC Administrator, it is forcing me to map a drive. If I do have to map a drive, it will have to be a client-side Windows mapping, and the server is generally NOT logged in. So, I'm thinking that mapping generally won't even be available. Am I correct in this thinking? Thanks for the help! Kevin -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 5:07 PM To: CF-Talk Subject: RE: Very odd behavior with data sources. please help if you can You can go to the Datasources (ODBC) section of the administrative tools in the control panel (assuming win2k, probably the same on NT4) and create data sources there. That's how you have to create data sources for dbs that CF doesn't support natively. Once created, you can configure CF-specific settings in the administrator. Of course, this only works if you're using ODBC, but if you've got access, that'll be no big deal. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.765.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 26, 2003 1:57 PM > To: CF-Talk > Subject: RE: Very odd behavior with data sources. please help if you can > > > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
