Stored Procedures run locally but not on a remote server
I can run the stored procedures from both the command line and from Query Browser locally, but when trying to call them from a remote server we get this error:
ERROR [23000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SPTest' at line 1
ODBC Error log lists error 23000 as an "Integrity constraint violation" whatever that means as there is no other detail.
Same results can be replicated with 2 different remote servers - one is running windows XP (with MySQL 5.0.27 server and ODBC client 3.51.11) on my LAN and the other is running Web Edition (MySQL 5.0.22 server and ODBC client 3.51.12) across the internet.
Code for calls is in C# using .NET 1.1
Thing is we can call queries fine but calling a stored procedure fails when called remotely. Any help would be greatly appreciated.
Thanks,
Lonnie
Subject
Views
Written By
Posted
Stored Procedures run locally but not on a remote server
1918
August 28, 2007 08:53AM
1036
August 28, 2007 08:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.