Hi, I connected to a MySQL-Server via "create server CLASS 'MYSQLODBC' USING ''" Then i created a external procedure. When i call "call test_procedure()" I got: [MySQL][ODBC 5.2(a) Driver]Commandsout of sync; you can't run this command now. any ideas? Thanks Markus |
Hi Markus, I tried reproducing this issue, but couldn't immediately do it with the MySQL 5.2.5 ODBC driver, against MySQL 5.5.28 in a very simple test. Here is what I tried doing: (MySQL SQL) delimiter $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `test_procedure`() BEGIN SELECT 1; END$$ (SQL Anywhere SQL) create server "testmysql52" class 'MYSQLODBC' using 'DSN=test_mysql_52'; create externlogin "DBA" to "testmysql52" remote login 'root'; forward to "testmysql52" {SELECT version()}; forward to "testmysql52" {call test_procedure()}; create procedure "DBA"."test_procedure"() at 'testmysql52;test_schema;;test_procedure'; call test_procedure(); All of these statements worked correctly for me - can you do the same? If these statements are okay, can you provide your exact sequence of steps and definitions for your MySQL procedure in order to reproduce this issue? Is it 'just' this one procedure that doesn't work? i did exactly the same if i call forward to "testmysql52" {call test_procedure()}; I works but call test_procedure(); still returns: [MySQL][ODBC 5.2(a) Driver]Commands out of sync; i'm using mysql 5.1.66
(11 Jun '13, 11:48)
Markus Koch
Replies hidden
I also missed an obvious question in my original response: which version and build of SQL Anywhere are you using? I was testing with SQL Anywhere 16.0.0.1535.
(11 Jun '13, 12:08)
Jeff Albion
with mysql-version 5.5.28 and odbc-version 5.2.5.0 i doesnt work on windows 32bit with asa 12.0.1.3873, too did you set any options in the odbc-settings?
(11 Jun '13, 12:24)
Markus Koch
|
Google returns this hit, does it help?
http://bugs.mysql.com/bug.php?id=68280
it works with Version 5.1 of the mysql odbc-driver, but not with 5.2?!?
Sorry, you did ask for "any ideas", and it wasn't clear that it worked before ( an important clue :)