PASSING DB CONNECTION VIA TEXT FILE

[maersk41]

I have to connect to 14 differnt databases depending on which once the user needs. I currently use a drop down menu to select what db they need and then in the newConnection method under datastream i do a simple case statement if "abc" then set newconnection = new abc_connection which is stored in a library file. this all works but i dont want to have to add this code to every datastream for each report. is there a way to pass my case statement into the datastream via a text file that i can update as we add new databases?? i tried creating a blank template datastream library function but when i add SQL it overwrites the blank template.

 

[tsabin]

I've got a similar problem.

We're runninga J2EE application on Tomcat under SunOS 5.7. The e.Reporting version is v6 Service Pack 1 Fix 5. The application is telling Actuate to get it's data from database A. Some of the JOD files point to database B in the <URL> tag. When Actuate sees the <URL> tag, it gets it's data from database B. Is there any way to force Actuate to always get it's data from database A?