disconnecting from database

[Alan Shum]

I'm developing in asp and connect to databases using something like this:
(using ODBC)

set db = Create.ServerObject("ADODB.Connection")
db.open "databaseName;"

This works fine and I can get and insert data with no trouble.  However,
when I do:

db.close
set db=nothing

Nothing happens.  The connection remains in sleep mode with no info (output
from process list) and only disconnects when the connection is timed out.
This is a problem when many users are using a page simutaneously with many
connections created... changing the max connection limit is not a real
option as it slows everything down when many connections are made.

Any idea on what I can do disconnect from the dabase?



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql support questions

[Alan Shum]

Hi

Does mysql work on WIN NT servers?  The technician from our web site
provider told me that mysql is a linux product and will only work on linux
servers.  Is that true?

At the moment I'm using a personal web server on Windows 2000 and I can work
with the mysql database with no trouble... this should be the same on the
server of our web site provider right??

Cheers

Alan Shum
Starf Ltd
PO Box 283
Orewa
Hibiscus Coast
NEW ZEALAND

Ph + 64 9 414 6172
Fax + 64 9 414 6182
Mobile 025 832 682

http://www.starf.net

CAUTION:  This message may contain privilaged and confidential information
intended recipient of this message, you are hereby notified that any use,
dissemination, distribution or reproduction of this message is prohibited.
If you received this message in error, please notify Starf ltd immediately.
Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of Starf Ltd.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php