[dba-SQLServer] sp_OACreate, was Re: Calling a Webservice...

So continuing on the previous thread, I'll need to call a dll that will 
ultimatley handshake w/ the webservice, but then comes the question... since 
sp_OAcreate can only be called by system administrators, how can I give an 
average user rights to call this service? 

any ideas?

On 7/19/05, Francisco Tapia <fhtapia at gmail.com> wrote:
> 
> In the middle of a design discussion for a system that is in development, 
> it was brought up if I could just call a webservice from a stored procedure. 
> That's my real question can it? Initially I figured that the website for 
> this system would take an order in, and submit the order to sql server, an 
> inhouse person would review the order and upon it's approval click the 
> approve button and allow the order to be submitted to the enterprise 
> database. Because the Sales Order number needs to be stored on the sql 
> server for refernce, I figured it would be easiest to have the inhouse 
> application call the stored procedure, and let the server go and talk to the 
> webservice and retreive the "Sales Order". If this cannot be done, then I'll 
> need to take all the data at the client side submit it and take the 
> resulting Sales Order and submit it to the sql server, giving it plenty of 
> room for errors due to network interuptions (rare I know, but sometimes not 
> quite)... Has anyone ever had to do this?
> 
> Thanks,
> 
> -- 
> -Francisco
> http://pcthis.blogspot.com |PC news with out the jargon!
> http://sqlthis.blogspot.com | Tsql and More... 
> 



-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...