I'm trying to make a java application which changes the reports database connection.
My reports use odbc connection.
I read the examples and I succesfuly changed to jdbc.oracle or jdbc.odbc but I want
to chnage the connection to oracle or other odbc.
I wrote the code:
IConnectionInfo connectionInfo = table.getConnectionInfo();
//Set new table connection property attributes.
PropertyBag propertyBag = new PropertyBag();
//Overwrite any existing properties with updated values.
propertyBag.put("Server Name", "aurel");
propertyBag.put("Connection String", "Server=s(aurel);User ID=s(aurel);Password=;Trusted_Connection=b(false)");
propertyBag.put("Server Type", "Oracle Server");
//Update old table in the report with the new table.
When I run it I got the error:
JRCAgent1 detected an exception: Database driver name is not supported: crdb_oracle.dll
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Database driver name is not supported: crdb_oracle.dll
This happened also when I use odbc connection with crdb_odbc.dll
I want to know if I can do that or is it impossible?
I don't need to change the connection for each table I like to change it for the entire report
like in crystal reports when use set datasource location but I don't find any support for that.