August 1, 2007 at 6:47 am
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.
August 1, 2007 at 2:43 pm
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]?
August 2, 2007 at 2:14 am
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?
August 2, 2007 at 2:35 am
Cracked it!
EXEC('CALL usp_test') AT MYSQLLOCALHOST
August 3, 2007 at 12:59 am
Interesting solution.
April 17, 2013 at 3:24 pm
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.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy