Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DAO recordset Call to SQL Stored Proc
I am trying to call a stored proc in DAO. I have a connection to the SQL DB and have defined a recordset object The line of code I am using is: Set rs = SQLcnn.OpenRecordset("vsp_TemplateGetID 533, '1234567890', 'argert'", dbOpenSnapshot, dbSQLPassThrough, dbReadOnly) In query analyzer if can successfully run: vsp_TemplateGetID 533, '1234567890', 'argert' When I try to set a recordset with the code then I get an error: Run time error 3001 Invalid argument Can someone please help me? -- Stewart Rogers DataSort Software, L.C. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADO recordset problem with stored procedure | Excel Programming | |||
Calling stored proc with parameters .. | Excel Programming | |||
return multiple results from stored proc | Excel Programming | |||
execte stored proc | Excel Programming | |||
Call a proc inside itself (HELP) | Excel Programming |