?
Solved

Database Error (urgent)

Posted on 2003-11-06
18
Medium Priority
?
870 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

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

Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
What You Need to Know when Searching for a Webhost Provider
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
Suggested Courses
Course of the Month12 days, 23 hours left to enroll

777 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