SQL server 2005 and geo web services

26/12/2007, 17h36

I've been using SQL Server 2000 and am not familiar with all the new
features in 2005 but I understand it has the ability to make web
service calls.
Is there a way to write a stored procedure that passes street/city/
state data to a web service and returns latitude/longitude by simply
using a sproc?
Any is appreciated.
lq

26/12/2007, 20h20

In SQL Server 2005 you can use HTTP endpoints to expose stored procedures or
user defined functions as Web methods. Here are a couple good articles that
describe that:
http://www.developer.com/db/article.php/3390241
http://www.devx.com/dbzone/Article/28525

However, seems you need to consume a Web service within a stored procedure,
not to expose. This can be accomplished in SQL Server 2005 via CLR (Common
Language Runtime). The articles below will show you examples of doing that:
http://www.simple-talk.com/sql/sql-s...lr-assemblies/
http://davidhayden.com/blog/dave/arc...4/25/2924.aspx
http://blogs.msdn.com/sqlclr/archive...25/Vineet.aspx

Although doable, SQL Server may not be the best place to make Web service
calls. Perhaps having an external application that makes the call and passes
results to SQL Server will be a better architecture.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

27/12/2007, 05h03

Plamen,
Thanks for the response. These links are exactly what I was looking
for. I have an Access front end so I'm looking for a solution that
will not require a seperate dot.net application to call the web
service.
lq

On Dec 26, 3:20pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> In SQL Server 2005 you can use HTTP endpoints to expose stored procedures or
> user defined functions as Web methods. Here are a couple good articles that
> describe that:http://www.developer.com/db/article..../Article/28525
>
> However, seems you need to consume a Web service within a stored procedure,
> not to expose. This can be accomplished in SQL Server 2005 via CLR (Common
> Language Runtime). The articles below will show you examples of doing that:http://www.simple-talk.com/sql/sql-s...25/Vineet.aspx
>
> Although doable, SQL Server may not be the best place to make Web service
> calls. Perhaps having an external application that makes the call and passes
> results to SQL Server will be a better architecture.
>
> HTH,
>
> Plamen Ratchevhttp://www.SQLStudio.com

26/12/2007, 17h36	#1
Lauren Quantrell Messages: n/a Hébergeur:	SQL Server 2005 and Geo Web Services I've been using SQL Server 2000 and am not familiar with all the new features in 2005 but I understand it has the ability to make web service calls. Is there a way to write a stored procedure that passes street/city/ state data to a web service and returns latitude/longitude by simply using a sproc? Any is appreciated. lq

26/12/2007, 20h20	#2
Plamen Ratchev Messages: n/a Hébergeur:	Re: SQL Server 2005 and Geo Web Services In SQL Server 2005 you can use HTTP endpoints to expose stored procedures or user defined functions as Web methods. Here are a couple good articles that describe that: http://www.developer.com/db/article.php/3390241 http://www.devx.com/dbzone/Article/28525 However, seems you need to consume a Web service within a stored procedure, not to expose. This can be accomplished in SQL Server 2005 via CLR (Common Language Runtime). The articles below will show you examples of doing that: http://www.simple-talk.com/sql/sql-s...lr-assemblies/ http://davidhayden.com/blog/dave/arc...4/25/2924.aspx http://blogs.msdn.com/sqlclr/archive...25/Vineet.aspx Although doable, SQL Server may not be the best place to make Web service calls. Perhaps having an external application that makes the call and passes results to SQL Server will be a better architecture. HTH, Plamen Ratchev http://www.SQLStudio.com

27/12/2007, 05h03	#3
Lauren Quantrell Messages: n/a Hébergeur:	SQL server 2005 and geo web services Plamen, Thanks for the response. These links are exactly what I was looking for. I have an Access front end so I'm looking for a solution that will not require a seperate dot.net application to call the web service. lq On Dec 26, 3:20pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote: > In SQL Server 2005 you can use HTTP endpoints to expose stored procedures or > user defined functions as Web methods. Here are a couple good articles that > describe that:http://www.developer.com/db/article..../Article/28525 > > However, seems you need to consume a Web service within a stored procedure, > not to expose. This can be accomplished in SQL Server 2005 via CLR (Common > Language Runtime). The articles below will show you examples of doing that:http://www.simple-talk.com/sql/sql-s...25/Vineet.aspx > > Although doable, SQL Server may not be the best place to make Web service > calls. Perhaps having an external application that makes the call and passes > results to SQL Server will be a better architecture. > > HTH, > > Plamen Ratchevhttp://www.SQLStudio.com

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email