Hi,
Thank you for your reply.
The third party uses JDBC. I'm to install the SAS JDBC drivers for win 10 but i'm getting the error "this application does not support your platform. I try the only two drivers available for windows.
I'm able to connect via Squirrel SQL and the connection works fine.
When I try to declare the libname, I get this error:
36 libname bean jdbc driverclass="com.jaspersoft.jdbc.driver.JasperDriver"
37 URL="jdbc:jaspersoft@https://cppmrpt4003.ondemand.ca.com/reportservice;datasource=/ca_ppm/data_sources/CA_PPM_BEAN;
37 ! pagesize=500" user=reportdev|cppm4001
38 password=XXXXXXXXXXX classpath="c:\lib";
ERROR: The JDBC engine cannot be found.
ERROR: Error in the LIBNAME statement.