Calling MySQL stored procedures viua a linked server

• dJeePe

  Say Hey Kid

  Points: 712

  More actions

  August 1, 2007 at 6:47 am

  #95379

  Does anyone know if it is possible to call MySQL stored procedures via a linked server setup? I've searched around the net and had a play myself but have had no luck so far.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  August 1, 2007 at 2:43 pm

  #724001

  When you ran a stored procedure on a remote heterogeneous data server, did you include full name of the stored procedure, such as [ServerName].[DBName].[Owneship].[StoredProcedure]?

• dJeePe

  Say Hey Kid

  Points: 712

  More actions

  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?

• dJeePe

  Say Hey Kid

  Points: 712

  More actions

  August 2, 2007 at 2:35 am

  #724099

  Cracked it!

  EXEC('CALL usp_test') AT MYSQLLOCALHOST

• Jo Pattyn

  SSC-Dedicated

  Points: 32420

  More actions

  August 3, 2007 at 12:59 am

  #724394

  Interesting solution.

• jie_yuan

  Valued Member

  Points: 71

  More actions

  April 17, 2013 at 3:24 pm

  #1607452

  Is there a way to get the value ( i.e. @rtn_cd) of the OUT varialbe in mysql stored procedure in MSSQL like the following ?

  EXEC('CALL usp_test(@rtn_cd)' ) AT MYSQLLOCALHOST

  If mysql procedure is created like this:

  create procedure usp_test(OUT return_code int)

  begin

  ..

  end;

  Thanks in advance.