Hi All,

I know this is a pretty open ending question, but I'm having trouble getting a populated recordset returned from a SQL Server stored procedure (which executes fine in SQL Query Analyzer). I've tried calling the stored procedure using the Connection object, Command object, Command object with named parameters, just about any example I could find on the net to no avail. I'm wondering if it's something as simple as a setting that I'm missing...

Here are the various ways that I've tried:

** oConn is already created and Open()

oRS = oConn.Execute("spSecurity_GetObjectsForUser @ObjectIDStart=1000, @Depth=-1, @UserAccountID=13, @ObjectTypeCSV='2', @MinimumPermissionLevel=100")
* No Errors, oRS state is 0 

oRS = oConn.Execute("spSecurity_GetObjectsForUser 1000, -1, 13, '2', 100")
* No Errors, oRS state is 0 

oRS = CREATEOBJECT("ADODB.Recordset")
oConn.spSecurity_GetObjectsForUser(1000, -1, 13, '2', 100, oRS)
* No Errors, oRS state is 0 

oRS = oConn.spSecurity_GetObjectsForUser(1000, -1, 13, '2', 100)
* No Errors, oRS state is 0 

The SQL Profiler shows the executing command which again, looks fine and executes in the SQL Query Analyzer.

Does anyone have an idea of what I can look for?


Thanks,

- Brian