Your SAS programs, embedded in web apps and elsewhere

Calling stored procedure from outside

Reply
N/A
Posts: 0

Calling stored procedure from outside

Hello.

I have a stored procedure which I call with a URL.In this URL it is defined which user that should run the stored procedure, and also the pass for this user (of course crypted).

The funny thing is that when I run this URL on the server where the stored procedure is, there is no problems. The stored procedure does what it has to do.

But when I run it in another client from the web. Nope. There is a timeout.
The portnumber that I use is opened on the firewall, so it isn't the firewall settings. Is there another permission problem on the URL and the stored procedure?

Can anybody help?

Best regards
HuGOB
SAS Super FREQ
Posts: 8,869

Re: Calling stored procedure from outside

Posted in reply to deleted_user
Hi:
My suggestion would be to contact Tech Support. They are better at debugging connection and stored process web app problems than anybody else I know.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 175 views
  • 0 likes
  • 2 in conversation