I am trying to use a stored procedure via Command. All it does is return a recordset.
.asp code:
<pre id=code><font face=courier size=2 id=code>
&lt;%
Dim cmdListings__UserEmail
cmdListings__UserEmail = "xyz" ' UserEmail is nvarchar(50) in the DB
if(Request("UserEmail" &lt;&gt; "" then cmdListings__UserEmail = Request("UserEmail"

Dim cmdListings__UserType
cmdListings__UserType = "xyz"
if(Request("UserType" &lt;&gt; "" then cmdListings__UserType = Request("UserType"
%&gt;
&lt;%
set cmdListings = Server.CreateObject("ADODB.Command"
cmdListings.ActiveConnection = MM_cnRealSite_STRING
cmdListings.CommandText = "american-listings.spShowListings"
cmdListings.Parameters.Append cmdListings.CreateParameter("@RETURN_VALUE", 3, 4)
cmdListings.Parameters.Append cmdListings.CreateParameter("@UserEmail", 200, 1,50,cmdListings__UserEmail)
cmdListings.Parameters.Append cmdListings.CreateParameter("@UserType", 200, 1,50,cmdListings__UserType)
cmdListings.CommandType = 4
cmdListings.CommandTimeout = 0
cmdListings.Prepared = true
set rsListings = cmdListings.Execute ' LINE 25
rsListings_numRows = 0
%&gt;
</font id=code></pre id=code>
MS SQL code
<pre id=code><font face=courier size=2 id=code>
-- View Property Listings
CREATE PROCEDURE spShowLisings (@UserEmail nvarchar(50) = '', @UserType nvarchar(50) = '')
AS
IF @UserType = 'Admin'
BEGIN
SELECT * FROM vwListings
END
ELSE
BEGIN
SELECT * FROM vwListings
WHERE UserEmail = @UserEmail
END
GO
</font id=code></pre id=code>

The SP runs from in query analyzer. Yet it returns this error from DMX and when browsed:
======================
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
/mylistings.asp, line 25

Edited by - wdglide on 03 May 2003 02:34:01

What's around line 25?

Regards,
Brent

Its the command.execute