Can anybody tell me by an example how I can execute SQLServer stored procedures with parameters in VB using OLE DB?

Thanks a lot

Similar to the below, although it will depend on what data types it's looking for (text or numbers) as to how you'll pass it.


ADODBConnection.Execute "[StoredProcedureName] 'Text'"

ADODBConnection.Execute "[StoredProcedureName] 24"

ADODBConnection.Execute "[StoredProcedureName] 'Text', 24"



____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

So, there's no difference between executing stored procedures by ADO and OLE DB?

Thanks again

Well, according to the control list in VB, the ADODC control (ado) is listed as "Microsoft ADO Data Control 6.0 (SP4)(OLEDB)" which adds the reference to the "Microsoft ActiveX Data Objects". So it would seem that OLEDB and ADO are the same in microsoft's eyes.

Or another simpler way from the help file (modified): OLE DB Support

OLE DB is a set of COM interfaces ... support the amount of DBMS functionality ... ADO is the way that programmers access OLE DB....