<div>
HI<br />
<br />
See EE Issue<br />
<a href="https://www.experts-exchange.com/questions/23444588/Calling-SQL-Stored-Procedure-from-Javascript.html" rel="ugc">https://www.experts-exchange.com/questions/23444588/Calling-SQL-Stored-Procedure-from-Javascript.html</a>
</div>


HI

See EE Issue
https://www.experts-exchange.com/questions/23444588/Calling-SQL-Stored-Procedure-from-Javascript.html [https://www.experts-exchange.com/questions/23444588/Calling-SQL-Stored-Procedure-from-Javascript.html]

<div>
Thanks for that,<br />
<br />
I have my connection as follows, but when I try to call it, I get an error saying it cannot find stored proc by that name. Any suggestions?<br />
<br />
Thanks<br />
<br />
<br />

<pre><code id="code-293727">function UpdateRecord() 
{
var connection = new ActiveXObject(&quot;ADODB.Connection&quot;);
connection.Open(&quot;Data Source=localhost\\TabletProject,1433;Provider=SQLOLEDB;User Id=sa;Password=xxxxx;Persist Security Info=True;Initial Catalogue=G41;&quot;); 
var r = connection.Execute(&quot;exec customrefproc&quot;); 
oppo_customref = r; 
}</code></pre>
</div>


Thanks for that,

I have my connection as follows, but when I try to call it, I get an error saying it cannot find stored proc by that name. Any suggestions?

Thanks




function UpdateRecord() 
{
var connection = new ActiveXObject("ADODB.Connection");
connection.Open("Data Source=localhost\\TabletProject,1433;Provider=SQLOLEDB;User Id=sa;Password=xxxxx;Persist Security Info=True;Initial Catalogue=G41;"); 
var r = connection.Execute("exec customrefproc"); 
oppo_customref = r; 
}

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'd like to know how / correct syntax I should be using to call a stored procedure in SQL Server from a script function in JavaScript.<br />
<br />
The environment I'm working in is Sage CRM however the answer to this question does not appear to need to be specific to any particular software.<br />
<br />
Thanks<br />

</div>
</div>


Hi,

I'd like to know how / correct syntax I should be using to call a stored procedure in SQL Server from a script function in JavaScript.

The environment I'm working in is Sage CRM however the answer to this question does not appear to need to be specific to any particular software.

Thanks


How to call a stored procedure from a function

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.

Enterprise Software

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.