I have an SQL database containing 2 procedures
each procedure takes 1 parameter
both procedures are owned by dbo
all users have exec permission on each procedure
I am using InterDev to create an ASP page.
I have added a connection and 2 DTC recordsets
the problem is when the page loads I get an error
Microsoft JScript runtine 0x800A0005
Invalid procedure call or argument
xxx.asp line 116
When I take out recordset 2 the page loads fine.
The problem only occurs when I add recordset2.
what could be wrong?
Both procedures are just simple queries on 1 or 2
tables where a specific column has a user entered value.
The columns have the same type and name in both procedures. they just retreive data from a different table.