Hi, > > Hallo, > > Im writing an Visual Basic 6 application, using MDAC 2.1 and MySql ODBC > 2.50.38. > > In some part of this application I like to know the processes that are > running on MySql. I'm using "SHOW PROCESSLIST" expecting a recordset back > like in "SHOW STATUS". I'm getting an runtime-error -2147467259 (80004005), > Function sequence error when I try to go to the first record (.MoveFirst). > This works ok with "SHOW STATUS". > > I traced the ODBC calls and enclosed the files. You can see that the "SHOW > STATUS" leaves no error in the trace file. The SHOW PROCESSLIST however > does. > > I hope you can give me an advice. > > Thanks in advance. > Frans Streur > -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=* > Frans Streur - 's-Hertogenbosch - The Netherlands > EMail [EMAIL PROTECTED] > -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=* > > Errors Tracefile: ----SHOW PROCESSLIST---- > > VB6 120-534 EXIT SQLNumResultCols with return code -1 (SQL_ERROR) > HSTMT 031F17E0 > SWORD * 0x0012E908 > > DIAG [S1010] [Microsoft][ODBC Driver Manager] Function > sequence error (0) >
What is its previous call ? Is it SQLPrepare or SQLExecDirect ? Note that, if it is SQLPrepare, then please upgrade your driver to .39 version to have a fix for this. Other wise, please send me the complete trace, but before that try with .39 version of the driver. NOTE: The error is returned by the DM, not by the driver, so we need to have a trace to understand what is happening from the application, and my guess is something to do with app calling sequence. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- 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