Solved

dsnless connection leaving access lockfile permanently open

Posted on 2002-04-21
4
162 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Coldfusion update database with CFLOOP 5 62
Forbidden errors 5 125
Problem to Eclipse 16 119
Internal DNS Alias (CNAME) - two domain names to one IP address 4 71
A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now