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!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple Stored Proc Problem

Status
Not open for further replies.
anyideas

anyideas

Programmer
May 2, 2002
127
GB
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(&quot;ADODB.Connection&quot;)

'Connect to the database
dbConn.ConnectionString = Application(&quot;CustomerServices_ConnectionString&quot;)
dbConn.ConnectionTimeout = Application(&quot;CustomerServices_ConnectionTimeout&quot;)
dbConn.Open

dbConn.Execute &quot;EXEC op_CSInsertCustomerCall 100&quot;

%>

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

<SCRIPT>

window.close()

</SCRIPT>

</BODY>
</HTML>
 
Sort by date Sort by votes
What (if any) errors are returned?

dbConn.Execute &quot;EXEC op_CSInsertCustomerCall 100&quot;
dim obj_Error
for each obj_Error in dbConn.Errors
Response.write obj_Error.Description & &quot;<br><br>&quot;
next codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
 
Upvote 0 Downvote
Thanks for responding codestorm

The browser just says

Page cannot be displayed

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error Type:
(0x80040E09)
/customerservices/datawrites/writeCallMade.asp, line 62
 
Upvote 0 Downvote
..and what happens on line 62? codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
 
Upvote 0 Downvote
dbConn.Execute &quot;EXEC op_CSInsertCustomerCall 100&quot;

I don't know if this helps...

I asked the browser for dbconn state and it returned 1


 
Upvote 0 Downvote
Sorry, I have to go to sleep, but my first suggestion is to use Command and Parameter objects (see ado210.chm or similar) codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
 
Upvote 0 Downvote
Sorted it out-

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

Thanks for trying

Mark
 
Upvote 0 Downvote
BTW, you should have gotten a more meaningful error in that case .. check that ou browser has user friendly error messages turned off. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Return to current location on page after asp processes.
Replies
2
Views
445
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
First execute an input command and only then proceed with displaying the next record of the table
Replies
0
Views
350
leifoet
leifoet
leifoet
  • Locked
  • Question
Problem: sql-Select with request.form
2
Replies
22
Views
561
leifoet
leifoet
leifoet
  • Locked
  • Question
How to log in without a popup problem?
Replies
3
Views
184
ggriffit
ggriffit
leifoet
  • Locked
  • Question
Form Method=Post =&gt; how to process options ?
Replies
0
Views
143
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top