Hello, I am using Drivers for JDBC to connect in my SAS Workspace. It is working good for all my BASE libraries, the problem is when I try to connect to a ODBC library. Class.forName("com.sas.rio.MVADriver"); Connection connection = DriverManager.getConnection("jdbc:sasiom://myserver.local:8591?librefs=MYLIBNAME '/sasdata/MYLIBNAME'", "myuser", "mypass"); This connection is working well, but I don't know how to set a libref when the library is ODBC and don't have a path like '/sasdata/MYLIBNAME'; When I list the libs, using: "libname _all_ list;" the result for are: First: I can connect (BASE lib) Libref= MYLIBNAME
Scope= IOM ROOT COMP ENV
Engine= META
Physical Name= /sasdata/MYLIBNAME
Filename= /sasdata/MYLIBNAME
Inode Number= 131073
Access Permission= rwxrwx---
Owner Name= myuser
File Size= 96KB
File Size (bytes)= 98304 Second: This I can't connect (ODBC lib) Libref= BI
Scope= IOM ROOT COMP ENV
Engine= META
Physical Name= BI
Schema/Owner= BI_STAGE Like you can see, in the second (ODBC lib) I don't have a Physical Name and Filename. So I don't know how to crate a connection in Java: Class.forName("com.sas.rio.MVADriver");
Connection connection = DriverManager.getConnection("jdbc:sasiom://myserver.local:8591?librefs=BI 'BI'", "myuser", "mypass"); This way doesn't work! Can you help me how I can assign the odbc lib in my Java connection? Thanks, Gustavo
... View more