Re: Maintain Database Connection

2002-09-17 Thread Jochem van Dieten
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

Re: Maintain Database Connection

2002-09-17 Thread Sean Daniels
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

Re: Maintain Database Connection

2002-09-17 Thread Bob Haroche
> 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

Maintain Database Connection

2002-09-17 Thread Greg Luce
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

Re: Maintain Database connection?

2001-05-30 Thread W Luke
;" <[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

RE: Maintain Database connection?

2001-05-30 Thread Mark Warrick
://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

Maintain Database connection?

2001-05-30 Thread Kola Oyedeji
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