Dear SAS community, I am trying to connect to a database via the SAS JDBC driver. Here are my codes and the error:
19 libname VHI JDBC classpath="C:\Program Files\SASHome\SASDriversforJDBC\9.4"
19 ! driverclass="oracle.jdbc.driver.OracleDriver"
19 ! url="jdbc:oracle:thin:@gilligan.cov.virginia.gov:1521:hawk10"
20 user="CJOSHI" pwd=XXXXXXXXX
21 schema=DM_VHI;
ERROR: Error trying to establish connection: ORA-01005: null password given; logon denied
ERROR: Error in the LIBNAME statement.
I confirmed that I typed my password correctly.
Thank you!
There are a couple ideas/examples of placing user and password in the URL part of the connection at this link:
https://stackoverflow.com/questions/5547224/username-password-in-jdbc-connection-url
There are a couple ideas/examples of placing user and password in the URL part of the connection at this link:
https://stackoverflow.com/questions/5547224/username-password-in-jdbc-connection-url
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.