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
