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