November 4, 2013 at 4:00 pm
Hi all,
I have many procedures written for a projects where we had to connect to MySQL database (there is an application sitting on top of it) from SS2008R2.
I am running OPENQEURYs into MySQL without problems, but yesterday my manager asked me to look into using that application's APIs to do the same.
His argument is that if changes are made on MySQL side, we'd have to make changes on our side ,but by using APIs, we won't have to. So, as I understand,
we'd have to come out from the database layer, make an API call and bring the result back into database.
Could you, please refer me to the site, document, .... where I can read more about the possibility to do so?
Thanks,
November 5, 2013 at 9:09 am
Given that this is a sql server site you are far more likely to get a decent response on a MySql site.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 5, 2013 at 10:25 am
Thanks for your reply.
Perhaps I did not explain this well. What I need is to call a web service from sql server.
November 5, 2013 at 10:36 am
Short answer - don't. Wrong tool for the job.
Oh you can write CLR procedures that can access web services, but that doesn't make them a good solution.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply