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
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
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
:-)
-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
-
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
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
-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?
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 matches
Mail list logo