Simple Stored Proc Problem

anyideas · May 17, 2002

Hi all.

I have an MSSQL stored Procedure which works when I access it from Query Analyzer but not from ASP.

The stored Proc has one value passed to it

Any help really appreciated!

Mark

The line in query analyzer is:

execute op_CSInsertCustomerCall 100

The code for my asp file is:

<%@ Language=VBScript %>

<%

Dim dbConn
Dim strSQL
Dim username

Set dbConn = Server.CreateObject("ADODB.Connection&quot

'Connect to the database
dbConn.ConnectionString = Application("CustomerServices_ConnectionString&quot

dbConn.ConnectionTimeout = Application("CustomerServices_ConnectionTimeout&quot

dbConn.Open

dbConn.Execute "EXEC op_CSInsertCustomerCall 100"

%>

<HTML>
<HEAD>
</HEAD>
<BODY>

<SCRIPT>

window.close()

</SCRIPT>

</BODY>
</HTML>

anyideas · May 17, 2002

Sorted it out-

The permissions of the stored procedure weren't set to EXEC for the user logged one

Thanks for trying

Mark

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Simple Stored Proc Problem

anyideas

Programmer

anyideas

Programmer

Similar threads

Part and Inventory Search

Sponsor