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.
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
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!
If you have SAS/ACCESS to SQL Server or SAS/ACCESS to ODBC then either of these would also work.
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.