Home Forums SQL Server 7,2000 In The Enterprise Calling MySQL stored procedures viua a linked server RE: Calling MySQL stored procedures viua a linked server

  • August 2, 2007 at 2:14 am

    #724091

    EXEC MYSQLLOCALHOST.rhys.root.usp_test

    /*------------------------

    EXEC MYSQLLOCALHOST.rhys.root.usp_test

    ------------------------*/

    OLE DB provider "MSDASQL" for linked server "MYSQLLOCALHOST" returned message "[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-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 '?=call "rhys"."root"."usp_test";1' at line 1".

    Msg 7212, Level 17, State 1, Line 1

    Could not execute procedure 'usp_test' on remote server 'MYSQLLOCALHOST'.

    I've tried the above and so many variations. Is there a way of passing a string (or sql) directly for the linked server to execute?