SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in [7.0.141 beta] Connection handling      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic [7.0.141 beta] Connection handling Author Message gemisigo Joined: 11 Mar 2010 Posts: 2109 [7.0.141 beta] Connection handling It looks like there's something wrong how the connections/query results are handled when connecting to a MySQL server from SQL Editor using a preset connect in DB Connections that is set to MySQL Native (with libmysql.dll). I get the following error when trying to run a stored procedure second time (or any other stored procedure / query after a stored procedure). Quote: Code 2014, Commands out of sync; you can't run this command now Thu Jul 10, 2014 6:15 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7849 This is a know issue I already see it in the list. There is some sort of conflict with the syntax checker interfering. It supposed to be run in a separate independent thread, but in MySQL it looks like the connection is not thread-safe. Thu Jul 10, 2014 8:51 am gemisigo Joined: 11 Mar 2010 Posts: 2109 Never mind, I changed the connection type to ODBC, it works properly under that. Thu Jul 10, 2014 8:56 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.