Re: CF not letting go of database connection?

2000-09-01 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-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-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

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 Jamie Keane
- 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 connection has been closed? If so, go to your

Re: CF not letting go of database connection?

2000-09-01 Thread Todd Ashworth
e. 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 would like to say

Re: CF not letting go of database connection?

2000-09-01 Thread Todd Ashworth
-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 after the last | connection has been closed?

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