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
