OLEDB connection to SQL Server

[katrina11]

Finally I was able to google an ODBC sulution which I looked for and recently posted:

http://www.tek-tips.com/viewthread.cfm?qid=1665286

The following is working:

LIBNAME MYLIBREF ODBC
COMPLETE="Driver={SQL Server};server=REPORTP01;Database=DW;" schema=DBO;

However, considering that ODBC/DSN connection was unstable in the past, now I am looking for OLEDB solution.

However OLEDB connection failed and generated the following error log:

50 %let db_link = SQLOLEDB ;
51 %let db_svr = REPORTP01 ;
52 %let db_tbl = DW ;
53 %let db_intsec = SSPI ;
54 %let db_sec = true ;
55
56 /* Link for OLEDB */
57 libname mylibref oledb provider = &db_link
58 properties = (
59 "data source" = "&db_svr"
60 "initial catalog" = "&db_tbl"
61 "Integrated Security" = "&db_intsec"
62 "Persist Security Info" = "&db_sec"
63 )
64 schema=DBO connection=shared readbuff=500
64 ! dbmax_text=200;
ERROR: The OLEDB engine cannot be found.
ERROR: Error in the LIBNAME statement.

What is wrong? What do you think? Any idea appreciated.

Thanks,
Katrin

 

[Karthikeyan74]

Have you resolved this issue. I am getting the same. Can you please help resolving