topic Re: ERROR: Unable to load oracle client (oci.dll) ERROR: Error in the LIBNAME statement. in ODS and Base Reporting

ERROR: Unable to load oracle client (oci.dll) ERROR: Error in the LIBNAME statement.

dedechance — Thu, 19 Jun 2025 13:35:50 GMT

I recently changed last names and now my local ODS will not connect to the old oracle client thus this error message: ERROR: Unable to load oracle client (oci.dll)
ERROR: Unable to load oracle client (oci.dll)
ERROR: Error in the LIBNAME statement.
How can I fix this on my local machine?

Re: ERROR: Unable to load oracle client (oci.dll) ERROR: Error in the LIBNAME statement.

JosvanderVelden — Fri, 20 Jun 2025 08:51:58 GMT

Please check if the indications by @ChrisHemedinger in the post https://communities.sas.com/t5/SAS-Programming/ERROR-oracle-client-loading/td-p/772282 help you to solve the issue.

Re: ERROR: Unable to load oracle client (oci.dll) ERROR: Error in the LIBNAME statement.

SASKiwi — Mon, 23 Jun 2025 01:08:56 GMT

I suggest starting from basics. Has your Windows account changed as a result of your surname change? Regardless I suggest then checking if you can then find the Oracle Client software installed on your PC under Windows "Apps and Features". If you can't find it then it will need to be reinstalled.