topic Call stored procedure odbc in SAS Procedures

Call stored procedure odbc

bob021 — Fri, 13 Apr 2012 10:08:18 GMT

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 — Fri, 13 Apr 2012 11:26:43 GMT

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 — Fri, 13 Apr 2012 11:40:55 GMT

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