dsnless connection leaving access lockfile permanently open

Posted on 2002-04-21
Medium Priority
Last Modified: 2013-12-24

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.
Question by:slackie
  • 2

Expert Comment

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

Author Comment

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.

LVL 37

Accepted Solution

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

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

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



Author Comment

ID: 6959536
That's true too.

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
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.
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

627 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