Solved

dsnless connection leaving access lockfile permanently open

Posted on 2002-04-21
4
167 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
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…

731 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