Dynamic DSN using the Web Component Server

[TheDrider]

I also posted this in Data Access forum, but with no answers. Can anyone here point me in the right direction?

I have a web application that uses many reports. The URLs link directly to the rpt files. Each report is coded to use a predefined DSN.

The problem is that we now have have multiple instances of the application on the same server, each with it's own copy of the code and database. However, each copy of the rpt file still uses the same DSN, which is wrong for the additional instances.

How can I change the dsn or server/dbname that the report is using at run-time? Most solutions mention using the OCX, but I'd rather pass a Connection string along the URL, since the URLs already point to the rpt file.

Any help would be appreciated...

 

[TheDrider]

Is it still possible to pass the reports to a web page that load the ActiveX viewer? I'm not sure if OCX methods were still supported in version 9.

If it is, can someone point me to the OCX and post a small usage example with parameters and a connection string?


The solution I need is to be able to have one rpt file on the web server, and have it execute against a dynamic database/server to be determined at run-time.

Any viable solutions for this in Crystal 9?