I'm trying to write a simple windows client to monitor my MySQL server. I'm using ADO and I can connect to the server fine from a remote host and issue queries using the ADO connection object like: set rs = conn.execute ("show databases") conn.execute("use " & strDBName ) set rs = conn.execute("show tables") no problem. However I was surprised when this didn't work (that is, it didn't return a recordset) set rs = conn.execute("show processlist") rs is empty, which is odd, because I thought I would at least see my own process. So I thought at first it might be Process_priv in mysql.user, but it is "Y" for this user and host. Oddly I can use the mysql GUI client (windows) on the same remote client, logging in as the same user and execute the statement "show processlist" and I get a recordset displayed. Am I missing something in the documentation (which I have read!) that treats the "show processlist" differently? All I'm really interested in is logging connections. I was trying to avoid starting mysqld with --log, because I'm not interested in logging the users queries. Is there an easy way to just log connections? Regards, Gary "SuperID" Huntress ======================================================= FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org --------------------------------------------------------------------- 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