Are you or someone else opening the database in their desktop? ----- Original Message ----- From: "Ruggiero, Kevin D" <[EMAIL PROTECTED]> Date: Friday, March 28, 2003 10:34 am Subject: RE: Very odd behavior with data sources. please help if you can
> 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 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
