If you have access to the CF Administrator, then you need to take the
timeout from 60 minutes to something lower. What this means is that the
database is released quicker, but this is advice only for development
servers only:-)
regards
Andrew Scott
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAI
I would like to see the flush.cfm code please!!!
Robert
- Original Message -
From: "Dru Whitledge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 05, 2000 4:47 PM
Subject: Re: Death to .ldb !!!
> Hi Peter,
>
> Tha
Hi Peter,
Thanks for the response. It turned out to be a CF problem with the CF
server holding open the database. There seems to be two effective
approaches to handles this -- a Flush.cfm file executed in a browser breaks
the connection and kills the .ldb file (This works like a champ -- did you
>From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, October 05, 2000 1:19 PM
>To: CF-Talk
>Subject: RE: Death to .ldb !!!
>
>
>I believe that when you are setting up the DSN if you DO NOT click maintain
>database connections this eliminates the problem.
>
" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 05, 2000 1:47 PM
Subject: RE: Death to .ldb !!!
> If you add this code to the bottom of your page, it should help alleviate
> some of the problems with the lock file.
>
>
>
> - Steve
>
>
>
CTED]>
cc:
Subject: RE: Death to .ldb !!!
I believe that when you are setting up the DSN if you DO NOT click maintain
database connections this eliminates the problem.
Shawnea
-Original Message-
From: Dru Whitledge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 12:34 PM
To
Dru,
The ldb file is used by access as well as Cold Fusion. So, if you have that
database open in Access on your desktop, an ldb file will be present. If
you close that database (don't have it open in Access on your desktop) the
ldb file on your hard drive should go away.
Hope that helps,
Pet
It's either one...
Howie
- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 05, 2000 1:22 PM
Subject: Re: Death to .ldb !!!
> I was under the impression it was an Nonexistent colu
down your server quite a bit. On a development server this may be
acceptable, but don't do this on a production server.
-Original Message-
From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 1:19 PM
To: CF-Talk
Subject: RE: Death to .ldb !!!
I believe
Stop and restart Cold Fusion Server. You can also go into the Cold Fusion
administrator and uncheck "maintain database connection" in the
datasource. Once a query is made, the .ldb file will disappear.
Jacob
At 10:34 AM 10/5/00 -0600, you wrote:
>If anyone else is working with MS Access you'v
If you add this code to the bottom of your page, it should help alleviate
some of the problems with the lock file.
- Steve
-Original Message-
From: Dru Whitledge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 12:34 PM
To: CF-Talk
Subject: Death to .ldb !!!
If anyone el
I was under the impression it was an Nonexistent column in an Existing
Table. That is what my customers use without a problem.
Thanks,
Neil
- Original Message -
From: "Dru Whitledge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 05, 2000 12:34 PM
Subject
Execute a bad query on the DB and CF will release it. Try:
select * from thistabledoesntexist
or something like that...
Regards,
Howie
- Original Message -
From: "Dru Whitledge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 05, 2000 12:34 PM
Subject: D
I believe that when you are setting up the DSN if you DO NOT click maintain
database connections this eliminates the problem.
Shawnea
-Original Message-
From: Dru Whitledge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 12:34 PM
To: CF-Talk
Subject: Death to .ldb !!!
If an
That .ldb file is created when Access is running, if your not running it
then CF Server may have it open. There is a check box in the CF Server
Admin that when unchecked will not maintain a connection to that db. If you
uncheck that and you don't have Access running you should be able to do it
n
Sure,
Make a file called flush.cfm or something... and put this code in it...
flushed.
Then call that file with your web browser, you might want to put some sort
of security on it. You can also go into the CF Administrator, and do this
under the Verify Datasources tab.
___
16 matches
Mail list logo