Hi SASKiwi, Thank you fro your reply. I'm new to this installation process, so not sure if my answers are correct. What I have here is SAS 9.4 with EG 7.1. I hope JDBC works with both. I'm intrigued that all the documentation specifies SAS Viya. For example, the link below: https://documentation.sas.com/?docsetId=dplyml0phy0lax&docsetTarget=n0xg0w4vqvat8gn102yocth6r1fa.htm&docsetVersion=3.4&locale=en It says Note: The information in this section is applicable only if you ordered SAS/ACCESS Interface to JCBC (on SAS Viya). But I also have SAS Studio and this link below says : From SAS Studio, edit and run the following SAS code to verify the SAS/ACCESS to JDBC LIBNAME statement: libname jdbc driver="full-jdbc-driver-name"
URL="jdbc-connection-url" username="user-ID" password="user-password"; If SAS/ACCESS to JDBC was successfully deployed, the execution of the LIBNAME statement will return results without error. When I run the code on SAS Studio, I also get the error like it wasn't deployed correctly. ERROR: The JDBC engine cannot be found. ERROR: Error in the LIBNAME statement. So I don't know. Perhaps I have to reinstall the whole thing.
... View more