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…

Submit a Comment

Your email address will not be published.

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!