Not maintaining database connections may solve the problem, but it may
affect performance. Say you have three queries to the same datasource on
the same page (not uncommon), then CF will release the connection, and
reconnect for each query. Imagine simultaneous accesses, and you've slowed
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 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 anyone else is working with MS Access you've probably had the same
annoying experience!!
I often have to swap backed up databases (.mdb files) and if I've been
using the old database that I want to copy over -- there is always a damn
.ldb (file / record locking file) in the directory that prevents me from
overwriting the old database.
I know how to cure this problem on the web (make a dummy query to a
nonexistent table in the same database) but that technique doe not seem to
work on my hard drive? I usually end up, annoyed as hell, having to re-boot
to be able to delete the damn thing off.
Does anybody know of a simpler way to dispatch this pesky little .ldb file
-- without rebooting?
Thanks,
Dru
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
