trying to execute a stored procedure (Insert) with parameters

[uncleroydee]

It's me again.

I'm making progress, baby steps, but this Interdev business is more than I expected.

I'm now trying to execute a stored procedure using the following:
<%SET rs = Server.CreateObject(&quot;ADODB.Recordset&quot
&quot;DSN=SURGEDB_SystemDSN;UID=sa;Password=;&quot;

rs.Open &quot;EXECUTE SP_SURGEDB_SOL_tst_ins '&amp;SNBRAGCY&amp;','&amp;SNBRYR&amp;','&amp;SNBRRFQTYPE&amp;','&amp;SNBRRFQISSUEORDER&amp;'&quot;, &quot;DSN=SURGEDB_SystemDSN;UID=sa;Password=;&quot;
%>

I'm getting the error message:
Microsoft VBScript compilation error '800a0400'

Expected statement

/SURGEDB_SP_TEST/insrt_tst/Insrt_step3.asp, line 12

^&quot;DSN=SURGEDB_SystemDSN;UID=sa;Password=;&quot;

I cannot figure out what message is expected.

Thanks in advance and Happy Holiday(s) of your preference

 

[palbano]

Roy,

You need a VB Scripter to help you with this problem. Try posting your ? in the ASP Forum here at Tek-Tips.

-pete

 

[culshaja]

Your open statement is completely wrong on the recorset.
Could you post the database you are calling i.e. SQL Server/Oracle etc.
What it is you are trying to do i.e call a stored proc, issue SQL statement.
The sql statement
What you expect to get back.

Thanks,

james James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[uncleroydee]

James,

This is the same issue we are discussing in the VB forum. Please disregard this posting.

Thanks and sorry for any inconvenience.

Roy