December 10, 2008 at 1:10 pm
Hello,
Anyone know if the above can be done? Pretty sure the answer is "no", but thought I'd ask the group.
I have successfully setup a linked server from SQL Server 2005 to mysql v5 and can easily execute cross-server joins using 4-part convention, but the performance is slow as it doesn't appear to be using the native mysql indexes on large tables.
What I'd like to be able to do is execute a mysql stored proc from sql server, such as:
execute mysqlsrv...sp_getorders '12/10/2008'
Seems like this should (eventually) be possible.
Thanks,
Joe
February 11, 2009 at 3:12 pm
Hi Joe,
I wonder did you ever get this working? I am trying to do the exact same thing and it isn't working.
Hope you can help.
Many Thanks in Advance
Stephen
February 12, 2009 at 6:57 pm
We use OPENQUERY() with a linked server on an older version of MySQL. I'm not sure if it will run a remote stored proc, but you might want to give it a try.
Dave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply