• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

dsnless connection leaving access lockfile permanently open

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
slackie
Asked:
slackie
  • 2
1 Solution
 
YogCommented:
have you closed the connection whenever you use. How are you calling from the cf page
0
 
slackieAuthor Commented:
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
 
meverestCommented:
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
 
slackieAuthor Commented:
That's true too.
0
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

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now