Congratulations on a good research and well documented post. It seems that reading the Access database triggers an http access to SharePoint. When you access the database from your PC, this link to SharePoint is not an issue. When you access the database from SAS, the link cannot work due to the restrictions placed on the SAS server. Is that a fair description? ... View more

Hi @bhuiyaas    There are system requirements that might be in place for Teradata that is the reason you are able to connect to it directly using a libname statement or a pre-assigned library. SAS/Access interface to OLE DB can be used to access data from Microsoft Access. I think it's supported only on Windows.   SAS/ACCESS Interface to OLE DB Base SAS software is required for the installation of SAS/ACCESS Interface to OLE DB. DBMS Product Required: An OLE DB data source provider Before you can use SAS/ACCESS Interface to OLE DB software, an OLE DB provider for the data source where you want to access data is required. OLE DB providers are often available from DBMS vendors and other third-party software vendors. The OLE DB provider that you select might require additional DBMS software for network access. All required network software supplied by your database system vendor must be 64-bit-compliant. The 64-bit version of the OLE DB provider is required for the data source. Ref: https://support.sas.com/documentation/installcenter/en/ikfdtnwx6sr/66390/PDF/default/sreq.pdf   To make a connection via libname: https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=p1a9wh7qwv6vc9n18arz94i379q0.htm&locale=en#n0zimj0va0mz1un1p77mad7c4oql   ... View more