Does anyone know of any problems using Stored Procedures that use the Prepare statement and Windows 2003 Server using the 3.51 ODBC Driver?
I have a Stored Procedure that creates a dynamic sql statement and then prepares and executes it.
It works great on my development computer Windows XP home, but it errors off if I try to run the same exact command under Windows 2003 Server.
I am using MYSQL 5.0.22 with ODBC 3.51 on both machines.
I am using the same DSN for both with the same username and passwords.
I can run the stored procedure under SQLYog which doesn't use the ODBC driver, but as I said the ODBC driver works fine on my Win XP machine.

I'm really stuck and hurting. Can anyone help?

Alan sawyer