Stored Procedure to Recordset 1

[sabloomer]

I have the existing code that works great...

'Create a connection to sql server
Set con = CreateObject("ADODB.Connection")
Set recordSet = CreateObject("ADODB.Recordset")

con.Provider = "SqlOleDB"
con.Properties("Data Source").Value = "MySERVER"
con.Properties("Initial Catalog").Value = "MyDatabase"
con.Properties("Integrated Security").Value = "SSPI"
con.Open

'Prepare command string to get number of columns
sql = "Select * from ReportTable"

'Open connection
recordSet.Open sql, con

I need to change the code to fill the recordset from a stored procedure. When I change the sql code def to ...

'Prepare command string to get number of columns
sql = "exec spReportTable @MyID= 25"

It looks like it runs but tells me the recordset is closed any time I try to use it. Does anyone have any suggestions?

Thank You,

sabloomer

 

[PHV]

Have a look at the Execute method of the ADODB.Connection object or at the ADODB.Commant object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

Sorry for the typo:
Have a look at the Execute method of the ADODB.Connection object or at the ADODB.Comman[!]d[/!] object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sabloomer]

Sorry for the delay in getting back to you.

Thanks to your suggestions I found...

http://msdn2.microsoft.com/en-us/library/ms807027.aspx

Which was a big help. I also needed to change my provider on the connection string, but once I was using the SQL Server driver and Execute Method all things fell into place.

Thank You,

Scott