INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Thanks for a great forum. My problem was answered just by scrolling through previously solved problems. Great service!!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Development Tools > Microsoft: Visual InterDev Forum

trying to execute a stored procedure (Insert) with parameters

Read More Threads Like This One

uncleroydee (TechnicalUser)

18 Dec 00 14:16

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("ADODB.Recordset")
"DSN=SURGEDB_SystemDSN;UID=sa;Password=;"

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

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

Expected statement

/SURGEDB_SP_TEST/insrt_tst/Insrt_step3.asp, line 12

^"DSN=SURGEDB_SystemDSN;UID=sa;Password=;"

I cannot figure out what message is expected.

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

palbano (Programmer)

19 Dec 00 0:11

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 (Programmer)

19 Dec 00 7:45

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 (TechnicalUser)

19 Dec 00 7:54

James,

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

Thanks and sorry for any inconvenience.

Roy

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Visual InterDev