topic Re: Connecting to Microsoft SQL Server using libname - ERROR: The OLEDB engine cannot be found in SAS Enterprise Guide

Connecting to Microsoft SQL Server using libname - ERROR: The OLEDB engine cannot be found

Abcd12233 — Wed, 31 Jan 2018 09:21:00 GMT

Hi,

I am trying to connect to a Microsft SQL Server in SAS EG 5.1. I can connect to this server using File->Open->OLEDB->Microsoft OLEDB Provider for SQL Server wizard, but it takes too long and I would like to connect using a libname statement.

Thanks so much in advance.

My code is:

libname mydblib oledb

datasource=sqlservername provider=sqloledb properties=('initial catalog'=db);

Running this code, I get the following error message in the log:

ERROR: The OLEDB engine cannot be found.

ERROR: Error in the LIBNAME statement.

Re: Connecting to Microsoft SQL Server using libname - ERROR: The OLEDB engine cannot be found

Damo — Wed, 31 Jan 2018 09:51:44 GMT

Hi @Abcd12233

It seems that the SAS/ACCESS Interface to OLEDB module is not licensed, not installed or both.

If you check your license, does it list the module ?

proc setinit; run;

If you check with SAS Foundation products are installed, does it list the module ?

proc product_status; run;

Hope that helps.

Cheers,
Damo

Re: Connecting to Microsoft SQL Server using libname - ERROR: The OLEDB engine cannot be found

RW9 — Wed, 31 Jan 2018 10:06:39 GMT

How do you believe using a libname will be any quicker than using the gui? It seems to you have a connection issue to the database, speak to your database admin/IT group to get it fixed.

Re: Connecting to Microsoft SQL Server using libname - ERROR: The OLEDB engine cannot be found

Damo — Wed, 31 Jan 2018 10:22:48 GMT

It's not using the same technology, that's my understanding.

When using File => Open => OLEDB, this is the message we get from EG (version 7.1 in my case)

My apologies if I say something silly (again)

Cheers,
Damo

Re: Connecting to Microsoft SQL Server using libname - ERROR: The OLEDB engine cannot be found

Abcd12233 — Wed, 31 Jan 2018 10:32:17 GMT

Hi Damo,

Thank you, this seems to be the problem. I don't see SAS/ACCESS Interface to OLE DB listed. Can you suggest any other ways I could use?

Thank you!

Re: Connecting to Microsoft SQL Server using libname - ERROR: The OLEDB engine cannot be found

SASKiwi — Wed, 31 Jan 2018 20:49:13 GMT

If you have SAS/ACCESS to SQL Server or SAS/ACCESS to ODBC then either of these would also work.

Re: Connecting to Microsoft SQL Server using libname - ERROR: The OLEDB engine cannot be found

LinusH — Wed, 31 Jan 2018 20:51:59 GMT

If you want something that is quicker, and fairly easy to use, you need to licence SAS/ACCESS to either OLEDB, ODBC or SQL Server.