Jim Lawrence
accessd at shaw.ca
Wed Jul 20 12:44:13 CDT 2005
Hi Francisco: Here is a link to a tool kit/white paper directed to MS SQL 2000 and managing webservices: http://www.microsoft.com/downloads/details.aspx?FamilyId=CA1CC72B-6390-4260- B208-2058C0BFD7DE&displaylang=en There might be something in this group of data that will help you. Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Wednesday, July 20, 2005 9:19 AM To: dba-sqlserver at databaseadvisors.com; SQL Server 2k List Subject: [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... _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com