what is the problem?

[bprego]

I keep getting this error when i try to execute a sp from my asp page.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
I can run the stored procedure in Query analyzer and it works great. So the problem has to be from the asp page to the database somewhere.

here is the code i am using.

<%
set Command1 = Server.CreateObject(&quot;ADODB.Command&quot
Command1.ActiveConnection = MM_SSS_Coe_STRING
Command1.CommandText = &quot;dbo.sp_appendimportdata&quot;
Command1.Parameters.Append Command1.CreateParameter(&quot;@OPERATOR_ID&quot;, 3, 1,4,Command1__OPERATOR_ID)
Command1.Parameters.Append Command1.CreateParameter(&quot;@JOB_ID&quot;, 3, 1,4,Command1__JOB_ID)
Command1.CommandType = 4
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>

Please, Please help me if you can. Thanks so much bprego

 

[ChrisHunt]

Try posting in the ASP forum: forum333

-- Chris Hunt

http://www.mcgonagall-online.org.uk

http://www.napitalia.org.uk

http://www.leicesteryha.org.uk

 

[Guru7777]

I need to see the code on the Stored Procedure to help you. If you post it, I can try to get you straightened out.