Solved

dsnless connection leaving access lockfile permanently open

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

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…
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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