...

View Full Version : database connection problem



dirksmith
04-24-2007, 12:06 AM
Hi everyone,

I hope someone here can shed some light onto a situation which I have encountered during development of a website which I inherited (I *hate* inheriting other people's work!).

I'm somewhat new to Windows servers and ASP - more of a Linux and PHP man *ducks for cover*

I got given the site below to complete:
www dot horse-quest dot com

I know it looks like a dogs dinner, that's besides the point.

The site gathers a lot of its page content from a Microsoft Access database using ADODB / Jet (I think thats right).

What is occuring is that every now and again when parts of a page go to connect to the database to retrieve data, the following error occurs:

"Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/includes/connections.asp, line 35"

All open connections to the database are closed, and the ASP code is as efficient as I can get it using common logic and object orientation.

Can someone explain to me why this error is occuring so often please? I mean, is it a server configuration setting? Does it only allow x amount of connections at one time? Should I upgrade the site to a MSSQL database?

Many thanks in advance,
Dirk

Archangel
04-24-2007, 02:46 PM
Maybe this will help you out a little bit?

http://tinyurl.com/yv9d9d

degsy
04-24-2007, 03:26 PM
If you are using an Access driver then try OLEDB instead.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum