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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.