Solved

dsnless connection leaving access lockfile permanently open

Posted on 2002-04-21
4
165 Views
Last Modified: 2013-12-24
Hi,

I am running a CF 5 server in Win 2000 Server SP2. I have recently started using dsnless connections to link to access databases for my websites. The problem I am having is that once a dsnless website is open, it opens the related access database, and never closes it. The lockfile remains there until the server reboots, even if the website is not being used for days/weeks. I can't delete the lockfile either. Does anyone know how I can either stop this from happening, or remove the lockfile.
0
Comment
Question by:slackie
  • 2
4 Comments
 
LVL 5

Expert Comment

by:Yog
ID: 6959490
have you closed the connection whenever you use. How are you calling from the cf page
0
 

Author Comment

by:slackie
ID: 6959493
I got the answer elsewhere. I just need to run this to flush out the database connections. The only problem is it flushes all databases connections so it shouldn't be done too often

This should be run in a cfm page on the server.

<cfscript>cfusion_dbconnections_flush();</cfscript>
0
 
LVL 37

Accepted Solution

by:
meverest earned 100 total points
ID: 6959525
i think that you can break the connection by running a bad query:

<cftry>
<cfquery ..etc..>
   select some_junk from non_exist_table
</cfquery>

<cfcatch type=any>
  <!--- DB RELEASED --->
</cfcatch>
</cftry>

maybe?

cheers.
0
 

Author Comment

by:slackie
ID: 6959536
That's true too.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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