<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Calling stored procedure from outside in Developers</title>
    <link>https://communities.sas.com/t5/Developers/Calling-stored-procedure-from-outside/m-p/23572#M2503</link>
    <description>Hello.&lt;BR /&gt;
&lt;BR /&gt;
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).&lt;BR /&gt;
&lt;BR /&gt;
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.&lt;BR /&gt;
&lt;BR /&gt;
But when I run it in another client from the web. Nope. There is a timeout. &lt;BR /&gt;
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?&lt;BR /&gt;
&lt;BR /&gt;
Can anybody help?&lt;BR /&gt;
&lt;BR /&gt;
Best regards&lt;BR /&gt;
HuGOB</description>
    <pubDate>Thu, 05 Jun 2008 21:00:35 GMT</pubDate>
    <dc:creator>deleted_user</dc:creator>
    <dc:date>2008-06-05T21:00:35Z</dc:date>
    <item>
      <title>Calling stored procedure from outside</title>
      <link>https://communities.sas.com/t5/Developers/Calling-stored-procedure-from-outside/m-p/23572#M2503</link>
      <description>Hello.&lt;BR /&gt;
&lt;BR /&gt;
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).&lt;BR /&gt;
&lt;BR /&gt;
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.&lt;BR /&gt;
&lt;BR /&gt;
But when I run it in another client from the web. Nope. There is a timeout. &lt;BR /&gt;
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?&lt;BR /&gt;
&lt;BR /&gt;
Can anybody help?&lt;BR /&gt;
&lt;BR /&gt;
Best regards&lt;BR /&gt;
HuGOB</description>
      <pubDate>Thu, 05 Jun 2008 21:00:35 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Developers/Calling-stored-procedure-from-outside/m-p/23572#M2503</guid>
      <dc:creator>deleted_user</dc:creator>
      <dc:date>2008-06-05T21:00:35Z</dc:date>
    </item>
    <item>
      <title>Re: Calling stored procedure from outside</title>
      <link>https://communities.sas.com/t5/Developers/Calling-stored-procedure-from-outside/m-p/23573#M2504</link>
      <description>Hi:&lt;BR /&gt;
  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.&lt;BR /&gt;
 &lt;BR /&gt;
cynthia</description>
      <pubDate>Fri, 06 Jun 2008 18:04:14 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Developers/Calling-stored-procedure-from-outside/m-p/23573#M2504</guid>
      <dc:creator>Cynthia_sas</dc:creator>
      <dc:date>2008-06-06T18:04:14Z</dc:date>
    </item>
  </channel>
</rss>

