> rs.open "sp_test 'strParmater1', 'strParameter2'" , cn, _
> adOpenDynamic, adLockOptimistic, adCmdStoredProc
>
> this gives me errors in the rs.open when passing parameters. No errors when not passing paramters.
> (I have even tried these: "EXEC sp_test 'paramter1', 'parametr2'"
> and "EXEC sp_test('paramter1', 'parameter2')"
> and "sp_test ('paramter1', 'parameter2')". I always get an error.
Let's start with the SP. Try calling the procedure from the Query Analyzer as:
EXEC sp_test @parameter1, @parameter2
Make sure you have the parameters declared and set to some values. What is the error there?
Aristotle