Call stored procedure odbc

[bob021]

Hi to All

Can somebody tell me how to call stored procedure in SAS?

I try with this but i received Error in the LIBNAME statement

libname mydblib odbc dsn=CC_DB_live user=**** password=**** dbconinit='call SP_WT_REPORT'

Thank you in advance.

Bob

[shivas]

Hi ,

Try this...hope it helps...

proc sql;

    connect to oledb(dsn=CC_DB_live  uid=test pwd=test provider=sqloledb);

           execute (SP_WT_REPORT ) by oledb;

quit;

Thanks,

Shiva

[bob021]

Hi

Thank you for respond.

I recieved this error

ERROR: The OLEDB engine cannot be found.

ERROR: A Connection to the oledb DBMS is not currently supported, or is not installed at your site.

Thank you again

Bob