|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
EXPLAIN output on 7.5.0.8 and ODBC connection pooling
iml-sapdb
i405.com
Date: Sat Apr 03 2004 - 19:32:32 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Howdy all,
On Wiin32 (Windows XP or Windows 2000) with latest MaxDB 7.5.0.8 driver and server... two systems (one server, one client). Using the
Unicode ODBC driver.
If I do these two queries from the same connection:
EXPLAIN SELECT field FROM TABLE
SELECT * FROM SHOW
I get my explain output... however, it only works if ODBC Connection Pooling is enabled on the MaxDB ODBC driver. If I turn off ODBC driver
connection pooling, it always fails saying that there is no SHOW table.
Also I'm still intersted in why one has to do the "SELECT * FROM SHOW" in the first place. I notice that the Python sample (posted previously
on the mailing list) does not have to do this. Does the python driver internally do the SELECT FROM SHOW 'automagically' and the ODBC
driver does not?
Reference python explain.py code: http://lists.mysql.com/maxdb/9229
Thank you.
Stephen Gutknecht
full time traveler with home on wheels
currently in Irving Texas, USA
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]