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)
Errors Tracefile: ----SHOW STATUS----
VB6 120-534 ENTER SQLGetDiagRecW
SQLSMALLINT 3
SQLHANDLE 031F17E0
SQLSMALLINT 1
SQLWCHAR * 0x0012E4AC (NYI)
SQLINTEGER * 0x0012E4CC
SQLWCHAR * 0x0012E0AC (NYI)
SQLSMALLINT 512
SQLSMALLINT * 0x0012E4C4
---------------------------------------------------------------------
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
