01-31-2018 04:21 AM
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.
01-31-2018 04:51 AM
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.
01-31-2018 05:32 AM
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?
01-31-2018 03:49 PM
If you have SAS/ACCESS to SQL Server or SAS/ACCESS to ODBC then either of these would also work.
01-31-2018 05:06 AM
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.
01-31-2018 05:22 AM
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)
01-31-2018 03:51 PM