.ldb file won't go away

BennyLefave · BennyLefave

I'm accessing MS Access 2002 databases using CF on my website. I've never had
a problem before with older pages and databases. I am now having issues with a
new database and a new page. Every time I access the db and display data on my
page I get a locking file that won't go away. I cannot FTP and overwrite this
db while the locking file is there. I have simplified my page down to one line
of of database access code using <cfoutput> but I still get the locking file
that won't go away. My page code is attached below. Does anyone have any idea
why the database would stay open? Thanks in advance.

<cfquery name="CompList" datasource="Active">
SELECT IDStatus FROM Active
WHERE Company='#form.office#'
</cfquery>

<cfparam name="SerialNum" type="string" default="">
<cfoutput query="CompList">
<cfset SerialNum=#IDStatus#>
</cfoutput>

<cfquery name="Checklist" datasource=#SerialNum#>
SELECT * FROM tblChecklist
WHERE UserName='#form.username#' and Password='#form.pword#'
</cfquery>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<HTML>
<HEAD>
<TITLE>Online Closing Checklist</TITLE>


<script type="text/javascript" language="JavaScript1.2"
src="../js/apymenu.js"></script>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta NAME="keywords" CONTENT="">
<meta NAME="description" content="Online Closing Checklist from ProDocs">

<link rel="stylesheet" href="ProDocsCSS.css" type="text/css">

</HEAD>

<BODY>

<table width="700" align="center"><tr><td>

<cfif #checklist.recordcount# IS NOT 0>
<table width="100%">
<tr>
<td width="100%">
<b>Office:</b>  <font class="blue">
<cfoutput query="Checklist">#ClearToClose#</cfoutput>
</font><br>
</td>
</tr>
</table>
</cfif>

</td></tr></table>

</BODY>
</HTML>

jorgepino · jorgepino

..ldb is created by access
everytime you open a access database it create a filename.ldb and it will go
away when you close the access database

first you will have to make the .mdb file inactive via cfadmin then ldb file
will go away

if you have a choice i would recomend to move from access to MYsql or if you
have the money to MSsql

hope it helps

dphillipsCFX · dphillipsCFX

Check your DNS properties in the CF administrator and make sure that the "maintain database connection" option is unchecked.

Dan Phillips
CFXHosting.com

BennyLefave · BennyLefave

Thanks for the reply.

I don't have access to the coldfusion administrator as our site is hosted by
Ready Hosting and they do all the administration. I only use the CF Admin for
testing local db's.

I don't understand why my other databases do not stay open after accessing
them and this new one does. There is no difference between the the new one and
the old ones as format is concerned and the code to access them is basically
the same. I contacted Ready Hosting and they said that something I am doing is
keeping the db open. Any help would be greatly appreciated.

mxstu · mxstu

Did you ask your host about the "maintain database connection" setting mentioned by dphillipsCFX above?

Roy F. · Roy F.

Hi Benny,

>Every time I access the db and display
>data on my page I get a locking file that
>won't go away.

If you send a junk query to the Access database, i.e. a query that will
throw an error, it should get rid of the .ldb file and allow you to FTP and
overwrite the database. However that .ldb file will get recreated the next
time you access the database. MS Access is not really a good choice for a
variety of reasons. If you have the option of using a true CS database, that
would be a better choice.

Regards,
Roy F.

"BennyLefave" <webforumsuser@macromedia.com> wrote in message
news:dgprnk$if$1@forums.macromedia.com...

> I'm accessing MS Access 2002 databases using CF on my website. I've never
> had
> a problem before with older pages and databases. I am now having issues
> with a
> new database and a new page. Every time I access the db and display data
> on my
> page I get a locking file that won't go away. I cannot FTP and overwrite
> this
> db while the locking file is there. I have simplified my page down to one
> line
> of of database access code using <cfoutput> but I still get the locking
> file
> that won't go away. My page code is attached below. Does anyone have any
> idea
> why the database would stay open? Thanks in advance.
>
>
> <cfquery name="CompList" datasource="Active">
> SELECT IDStatus FROM Active
> WHERE Company='#form.office#'
> </cfquery>
>
> <cfparam name="SerialNum" type="string" default="">
> <cfoutput query="CompList">
> <cfset SerialNum=#IDStatus#>
> </cfoutput>
>
> <cfquery name="Checklist" datasource=#SerialNum#>
> SELECT * FROM tblChecklist
> WHERE UserName='#form.username#' and Password='#form.pword#'
> </cfquery>
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
> "http://www.w3.org/TR/html4/loose.dtd">
> <HTML>
> <HEAD>
> <TITLE>Online Closing Checklist</TITLE>
>
> 
> <script type="text/javascript" language="JavaScript1.2"
> src="../js/apymenu.js"></script>
>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <meta NAME="keywords" CONTENT="">
> <meta NAME="description" content="Online Closing Checklist from ProDocs">
>
> <link rel="stylesheet" href="ProDocsCSS.css" type="text/css">
>
> </HEAD>
>
> <BODY>
>
> <table width="700" align="center"><tr><td>
>
> <cfif #checklist.recordcount# IS NOT 0>
> <table width="100%">
> <tr>
> <td width="100%">
> <b>Office:</b>  <font class="blue">
> <cfoutput query="Checklist">#ClearToClose#</cfoutput>
> </font><br>
> </td>
> </tr>
> </table>
> </cfif>
>
> </td></tr></table>
>
> </BODY>
> </HTML>
>

Mountain Lover · Mountain Lover

OR are you storing client variables in that DB? CFMX will keep the .ldb
file open even if the "maintain database connection" is unchecked

HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

BennyLefave · BennyLefave

My web host has to be the problem. When I run the site locally and query the
db's I get no locking file. I contacted Ready Hosting and they said it's an
Access problem, so they're basically not trying to help and telling me to go
talk to Microsoft....No thanks. I told them to check their OBDC settings for
the "Maintain Connection" option on all new DSN connections that are created.
Still waiting to hear back. Thanks for all the replies everyone.

BennyLefave · BennyLefave

UPDATE: Ready Hosting says they "Maintain Connections" checkbox is clear, and is off by default for new DSN connections. This is driving me nutty!!!!!!!!!! I don't know what else to do.

Roy F · Roy F

Hi Benny,

> UPDATE:........

Did you try the junk query I suggested? Put the following query on it's
own page on on your server and pull up that page. Substitute the
#request.dsn# for whatever your data source is.

<cfquery NAME="baddata" DATASOURCE="#request.dsn#">
Select BadData FROM UnknownTable
</cfquery>

This should get rid of the ldb file.

Regards,
Roy F.

BennyLefave wrote:

> UPDATE: Ready Hosting says they "Maintain Connections" checkbox is clear, and is off by default for new DSN connections. This is driving me nutty!!!!!!!!!! I don't know what else to do.

EssKayKay · EssKayKay

Roy,

We are having the same problem. Could you explain your solution a bit more? Is there a way to create a bogus query from the Query Builder as I am not a programer?

Thanks,
SKK

Roy F · Roy F

Hi SKK,

>Could you explain your solution a bit more?

I wouldn't call it a solution, more like a workaround. There's not much
more to explain. For whatever reason when you send a bogus query to the
access database the error causes the lock file to be deleted. The
solution to the problem is to not use Access as your database.

>Is there a way to create a bogus query from the
>Query Builder as I am not a programer?

Really all you have to do is use the exact same query I gave in my last
post, replace the dsn with yours, put it in it's own cfm page on your
server, and then go to that page in your browsers like you would go to
any other page. That's all you need to do. The query will error out and
you'll find the ldb file is gone. Hope this helps.

Roy F.

EssKayKay wrote:

> Roy,
>
> We are having the same problem. Could you explain your solution a bit more? Is there a way to create a bogus query from the Query Builder as I am not a programer?
>
> Thanks,
> SKK
>

.ldb file won't go away

Thread Tools

Display

.ldb file won't go away

Similar Questions and Discussions

problem in binding xml file data to datagrid xml file isgenerated through JSP file

File Viewer / Bloated file sizes / What is the best file format?

Open file, make changes, save file, close, re-open, file contents not changed

[BUG] File#rewind, File#syswrite, File#pos on Cygwin build

Confused about locking a file via file.flock(File::LOCK_EX)

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Re: .ldb file won't go away

Posting Permissions