Executing SQL procedure across the local network: SQL2005

Question

Executing SQL procedure across the local network: SQL2005

BOR15K

SSCertifiable

Points: 5894
More actions
February 21, 2008 at 9:04 am

#71324

Dear All,
I have two servers: 64BIT SQL and 32BIT Application one.
How can I use http:// statement, same as I use for Oracle?
Tried to find some info in ISS ( of Windows 2003 )m but with no success.
Here's Oracle's example:
http://my_oracle:7777/brs/my_schema/my_package.my_procedure?my_first_param=123456&my_second_param='20080212'
Kind Regards,
Zeev Kazhdan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 1

Do you mean execute a stored procedure through an HTTP call?

You can do this in SQL Server. Books online has information about SOAP endpoints, which will do what you are asking. Your links does not seem to work, so I'm guessing.

http://technet.microsoft.com/en-us/library/ms345123.aspx

BOR15K SSCertifiable Points: 5894 More actions · Answer 2

Thank you for the reply,

The syntax I've typed here works for Oracle ( just changed the real names to the my_ ones ). Can you give me some more clues / details to search?

Kind Regards!

BOR15K SSCertifiable Points: 5894 More actions · Answer 3

Thank you for the link - I read it, but as I am newbie to this sing in Microsoft, didn't have a progress.

Hope there is another way to solve my problem:

I have SQL installed on 64BIT server and my application - on 32BIT, which means I can't use OSQL f.e.

Are there any other ways to call to the procedures?

Kind Regards,

Zeev