Bob Haroche wrote:
>
> This is possible, but not recommended, especially if it is a
> multi-user database. To do so, however, clear the cached connection
> information with the following code:
>
>
With CF MX, you need to disable the datasource and then restart the
DataSourceService.
http://sp
uncheck
> "Maintain Database Connection" for the datasource and they came up with
> some BS answer that it keeps multiple connections being made. Isn't it
> just for efficiency so CF doesn't have to connect every time a call is
> made? Through the host's user interface
> I've tried putting up a bogus page with an invalid SQL
> query. Isn't that supposed to release it?
That works for me provided the bogus query in fact returns an error.
Another way to go is to use the following undocumented tag, which I've never
tried. But here's an excerpt from a post a while
Can someone clear this up for me. I maintain a site on a shared server
and it uses access :-(. Seems every time I need to alter the mdb file
it's locked on the server. I've asked the hosting company to uncheck
"Maintain Database Connection" for the datasource and they came up
;" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May 30, 2001 11:40 AM
Subject: Maintain Database connection?
> Hi
>
> Just a quick questions regarding the Maintain Database Connections in
> Access,
> should this be checked or unchecked and
://www.fusioneers.com
http://www.warrick.net
> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 30, 2001 3:36 AM
> To: CF-Talk
> Subject: Maintain Database connection?
>
>
> Hi
>
> Just a
Hi
Just a quick questions regarding the Maintain Database Connections in
Access,
should this be checked or unchecked and if it is unchecked what are the
performance
implications?
Thanks
KOla
~~
Structure your ColdFusion code with Fusebox. Get th
7 matches
Mail list logo