topic Re: Installing interface/access OLE DB instruction in Administration and Deployment

Installing interface/access OLE DB instruction

Riana — Mon, 04 Sep 2017 11:40:30 GMT

Hi,

Do you know where I can find instruction file(PDF) about SAS interface/access OLE DB installation on Unix environment?

Thanks.

Re: Installing interface/access OLE DB instruction

nhvdwalt — Mon, 04 Sep 2017 11:44:31 GMT

Hi Riana

That enigine is only supported on Windows. Have a look here...

http://support.sas.com/idsearch?qt=spr:%229.4qq_OLEDByy_%22+contenttype:%22System%20Requirements%22&s1=3&la=en&qm=3&col=suppprd&ct=203012

Re: Installing interface/access OLE DB instruction

nhvdwalt — Mon, 04 Sep 2017 11:53:16 GMT

Do you maybe mean SAS/Access to ODBC on UNIX ?

Re: Installing interface/access OLE DB instruction

Riana — Mon, 04 Sep 2017 11:54:01 GMT

Thank you. This is for Windows and I need it for Unix box. I couldn't find instruction for Unix environment?

Re: Installing interface/access OLE DB instruction

Riana — Mon, 04 Sep 2017 11:57:03 GMT

No, OLE DB . I need to install OLE DB interface for access to OLAP in SAS.

Re: Installing interface/access OLE DB instruction

nhvdwalt — Mon, 04 Sep 2017 12:02:53 GMT

SAS/Access to OLE DB is not supported on UNIX, hence there is no documentation for it.

What is the use case here ?

Re: Installing interface/access OLE DB instruction

SASKiwi — Mon, 04 Sep 2017 20:17:36 GMT

SAS/ACCESS to ODBC - ODBC is a much more widely-supported database interface standard than OLE DB. Note Microsoft announced that SQL Server 2012 was going to be the last version to support OLE DB:

https://en.wikipedia.org/wiki/OLE_DB

However apparently it is still being supported in more recent versions.