I am having a problem with VB script in an Excel spreadsheet that is calling a stored procedure. The stored procedure I am calling is used by other spreadsheets and has a sorting method that I want to override. I don't want to change the stored procedure, but just change the sort order in the ADO recordset.
In order to accomplish this, I am using the "SORT" property of the recordset. I set this property to the "entry_on" field name.
Example: rs.sort = "entry_on"
When I do this, I get a 3251 runtime error:
"Current provider does not support the necessary interfaces for sorting or filtering." Any ideas on how to work around this problem? BTW: The connection is using a "SQL Server" as the provider. Thanks!
In order to accomplish this, I am using the "SORT" property of the recordset. I set this property to the "entry_on" field name.
Example: rs.sort = "entry_on"
When I do this, I get a 3251 runtime error:
"Current provider does not support the necessary interfaces for sorting or filtering." Any ideas on how to work around this problem? BTW: The connection is using a "SQL Server" as the provider. Thanks!