- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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