Execute Stored Procdure from Javascript(JS) file

AbrarNazeer · March 18th, 2008, 04:25 AM

How to get a scalar value output by Executing a SQL Server's Stored Procdure from Javascript(JS) file.
Although there are some examples on internet with Server object i.e
Server.CreateObject("ADODB.connection")
but i m seeing the error "Server is undefined". If i put this code on a web page (e.g aspx - asp.net 2.0 ) then it will work fine. But my requirement is to Execute this code from JS file.
(JS file is called by an HTML page via a Script tag.
<script type="text/javascript" src="myFile.js"></script> )

joefawcett · March 18th, 2008, 06:39 AM

If you want to use a client-side script to execute a stored procedure then it's possible but unusual. You'd have to be able to create ActiveX on the client (or use a Java applet).
You can use:

Code:

var oConn = new ActiveXObject("ADODB.connection");

then set the connection string etc. I have done this in the past on a company intranet when for some reason server-side scripting was not possible but it can leave your SQL Server open to attack as anyone can read the connection string and use the information to connect directly.

--

Joe (Microsoft MVP - XML)