?
Solved

Database Error (urgent)

Posted on 2003-11-06
18
Medium Priority
?
873 Views
Last Modified: 2013-12-20
Hi

I've got a major problem with my company Intranet in that when several people are trying to access similar pages that use the same database I get errors saying 'cannot read database - file already in use'.  It works fine if there isn't heavy traffic.  I'm using an Access database.

Should this happen?  i thought Coldfusion would be able to handle several requests at the same time.  I may be being completely niaive here - I am a newbie.

Is there anything I that I could be doing that is fundamentally wrong?  Is there anything I can do in the Coldfusion Administrator to stop this happening?

Any help gratefully recieved.

Thanks in advance.
0
Comment
Question by:nelliott
  • 6
  • 4
  • 4
  • +3
18 Comments
 
LVL 2

Assisted Solution

by:jonnygo55
jonnygo55 earned 400 total points
ID: 9696173
in Cold Fusion administrator go to the ODBC Data Sources...click on the relevant one...click on CF Settings to expand the options....click on limit connections...set box to three(I think thats the max for access)...not many..think about upgrading to SQL server if your company has the money or MySQL if not
0
 
LVL 2

Expert Comment

by:jonnygo55
ID: 9696204
0
 
LVL 1

Assisted Solution

by:kjuliff
kjuliff earned 400 total points
ID: 9696439
Also check that no one is using the database NOT from your intranet. Is any application other than CF using it?

Also go to Datasources in the administrator and then CF Settings and make sure this is NOT checked

 Maintain database connections - Check this
box to maintain connections to data sources across client requests.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 1

Expert Comment

by:kjuliff
ID: 9696442
PS - THEN reboot the machine that the database resides on.
0
 
LVL 12

Expert Comment

by:jyokum
ID: 9696739
someone probably has the database open in Access and has one of the tables open in design mode. If you can't hunt them down, do as kjuliff suggested... reboot the server the database resides on.
0
 
LVL 17

Accepted Solution

by:
anandkp earned 200 total points
ID: 9698936
In ur CFAdmin -> Data Sources ... go to ur DSN & click on advanced settings ...
u'll see Maintain DataBase Connections - UNCHECK this !

that shld do it.

PS : kjuliff - u mentioned "Maintain database connections - Check this " - whereas it shld be unchecked - right ????

K'Rgds
Anand
0
 
LVL 10

Expert Comment

by:substand
ID: 9699327
place <cftransaction> tag around your queries.
0
 

Author Comment

by:nelliott
ID: 9700021
Still having problems.  I realise Access is not really set up for multi user requests, but I thought Coldfusion could cope with more than 2 people using it at the same time!  Am I right in thinking that Coldfusion should stack queries and deal with them one by one?

Within Coldfusion Administrator I have the following settings:

Data Sources

CF Data Source Name: intranet
Database File: E:\Inetpub\wwwroot\assets\db\intranet.mdb (Should this be in the System Database field? - what's the difference?)

Maintain Connectiosn is NOT checked.


Server Settings

Maximum number of simultaneous requests: 5

(Nothing else checked)


Caching Settings

'Save Class Files' and 'Cache Web Server Paths' are the only things ticked.


Each query within my cfm pages is set up as so:

<cfquery name="main_news" datasource="intranet" cachedwithin="#CreateTimeSpan(0,2,0,0)#">
SELECT ID, SUBMITTED, CATEGORY, NAME, CONTENT
FROM MAIN
WHERE CATEGORY = 'Headline News'
ORDER BY ID DESC</cfquery>


Any help gratefully recieved!!!  Thanks in advance...
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9700521
yes change ur DSN from USer DSN to system DSN & let me know
0
 

Author Comment

by:nelliott
ID: 9700811
I get this error message when I tey and add the database to System DSN

Connection verification failed for data source: intranet
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]Unable to retrieve error message from backend ODBC Driver.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]Unable to retrieve error message from backend ODBC Driver.

Any ideas?
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9700905
what version of CF are u using ?
0
 

Author Comment

by:nelliott
ID: 9700913
6.1
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9700954
Enterprise / Professional ?
0
 

Author Comment

by:nelliott
ID: 9700965
Standard Edition Version 6.1
0
 
LVL 1

Expert Comment

by:kjuliff
ID: 9701797
OK. Is the dababase on the same machine as CF? If not go to services and change the login for the CF  service to the network administrator account.
0
 

Author Comment

by:nelliott
ID: 9701965
The database is on the same machine as CF.
0
 
LVL 1

Expert Comment

by:kjuliff
ID: 9702552
OK. Then you shouldn't have to worry about the CF login account. The problem MAY be that it wasn't initially set up as a system
DSN.

I would do this - delete ALL dsn entries (in CF AND ODBC) for this database.

Reboot.

Set up as system DNS and limit simultaneos connections to 3.
0
 

Author Comment

by:nelliott
ID: 9713848
I have run out of ideas, so I've changed the database to MySQL.  Looks to have solved the above problem, although it is bringing in it's own little problems (aaargghhh!)

Thanks for your all your help.

Points split between kjuliff, anandkp and jonnygo55
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…
Suggested Courses
Course of the Month14 days, 8 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question