Error trying to establish connection: ORA-01005: null password given; logon denied

cjoshi1 — Thu, 20 Apr 2023 15:41:54 GMT

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!

Re: Error trying to establish connection: ORA-01005: null password given; logon denied

ballardw — Thu, 20 Apr 2023 22:16:07 GMT

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

topic Re: Error trying to establish connection: ORA-01005: null password given; logon denied in SAS Programming

Error trying to establish connection: ORA-01005: null password given; logon denied

Re: Error trying to establish connection: ORA-01005: null password given; logon denied