Does anyone have an example of using ADO CommandText with input parameters and a native SQL Server connection?

Question:
SQL Server Native Connection, ADO Command, and Parameters

Does anyone have an example of using ADO CommandText with input parameters and a native SQL Server connection?

? parameters and the SLX OLE DB Provider work fine…..except it has the tremendous additional query overhead of the SECCODE joins for Non ADMIN users…..SLX OLE DB Provider performance for a scan of 100,000+ records is NOT acceptable.

‘Named’ Parameters like ? or @P1 don’t work with the SQL Server 2005 connection, yet…..

any hints?

Maybe a stored procedure command call instead?

SELECT A1.OPPORTUNITYID FROM OPPORTUNITY A1 WHERE OPPORTUNITYID LIKE ?

or the equivalent would be perfect.

Answer:
don’t try to Set RS = objCMD.Execute…..

instead: RS.Open objcmd.execute and all is well…