Re: CF not letting go of database connection?

2000-09-01 Thread Todd Ashworth
t | seem to work either. | | Boris | | -Original Message- | From: Todd Ashworth [mailto:[EMAIL PROTECTED]] | Sent: September 1, 2000 7:10 AM | To: [EMAIL PROTECTED] | Subject: Re: CF not letting go of database connection? | | | Do you mean that the database engine stays running even

Re: CF not letting go of database connection?

2000-09-01 Thread Todd Ashworth
ase. Are you speaking in reference to SQL Server by any chance? Todd Ashworth - Original Message - From: "Andrew Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 01, 2000 11:12 AM Subject: RE: CF not letting go of database connection? | I w

Re: CF not letting go of database connection?

2000-09-01 Thread Jamie Keane
Original Message- From: Todd Ashworth <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, September 01, 2000 10:03 AM Subject: Re: CF not letting go of database connection? >Do you mean that the database engine stays running even after the last >co

RE: CF not letting go of database connection?

2000-09-01 Thread Andrew Scott
:-) -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Saturday, 2 September 2000 12:10 AM To: [EMAIL PROTECTED] Subject: Re: CF not letting go of database connection? Do you mean that the database engine stays running even after the last connection has been closed? If so, go

Re: CF not letting go of database connection?

2000-09-01 Thread Todd Ashworth
Do you mean that the database engine stays running even after the last connection has been closed? If so, go to your ODBC administrator in your control panel and open the properties for the DSN in question. Under the "Database" tab, you will have 2 checkboxes at the bottom. One is to automaticl

RE: CF not letting go of database connection?

2000-09-01 Thread Lon Lentz
I would only suggest this if you absolutely know the maximum time for any request from the table. In your config file there is a setting, TI, which is client idle time before shutdown. It defaults to 240 minutes I believe. You can adjust this. Now, if there is idle time between the CF request

Re: CF not letting go of database connection?

2000-08-31 Thread Jacob
I do not know about Sybase, but in SQL and Access there is a setting to maintain database connections. Uncheck this setting if there is one. Jacob At 10:20 AM 8/31/00 -0700, you wrote: >I have a number CF based pages that once the query is completed with the >data presented it will not let go

Re: CF not letting go of database connection?

2000-08-31 Thread Chad
If you make the page error then it should let go of the database. Stick a #badvariable# in the code then load the page in your web browser. That works on MS Access databases at least. Another option is to goto the CFadministrator and hit the verify button on the database. At 10:20 AM 8/31/

RE: CF not letting go of database connection?

2000-08-31 Thread Benjamin S. Rogers
This is a setting in the ColdFusion administrator. By default, ColdFusion keeps connections open to save on the overhead of having to establish (and kill) a new connection with every query. In general, it is a good thing, but you can turn it off if necessary. I have seen some instances where Micr