Skip to Content
0
Former Member
May 07, 2007 at 09:49 PM

change report database connection

213 Views

Hi

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("Trusted_Connection", "false");

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");

propertyBag.put("Database DLL","crdb_oracle.dll");

connectionInfo.setAttributes(propertyBag);

connectionInfo.setUserName(user);

connectionInfo.setPassword(pass);

table.setConnectionInfo(connectionInfo);

//Update old table in the report with the new table.

databaseController.setTableLocation(table, tables.getTable(i));

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.

Thanks.