Specifying database in URL for Crystal Web Component Server

We are using the standard edition of Crystal Enterprise version 8 to deliver reports via our internet.  The reports are selected from a menu and parameters entered into a form.  This is then transformed into the appropriate URL using PHP.

I have read the documentation on "URL Commands for the Web Component Server" (ce8_url_commands.pdf) which has a section on "Logging onto your Database", but have not been able to get change the database from that which the report was originally designed with.

The documentation does specifically refer to "SQL or ODBC databases", but we are using OLEDB for our connection.

Can anyone tell me how to specify parameters in the URL that will allow me to specify a different database for OLEDB.

Thanks

H.
LVL 5
Hamlet081299Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
frodomanConnect With a Mentor Commented:
No, what I meant was that you can change the ODBC connection itself.  If changing db's is something you want to do then you'll probably want to use an ODBC connection that is specifically for this report and then you can change the ODBC connection itself to point to the new db.

AFAIK you can't change the db through the URL itself - you'd have to manually change the odbc or run code to do so before calling the report.

frodoman
0
 
frodomanCommented:
Hamlet,

To the best of my knowledge if the report is created with an OLEDB connection you cannot change it from the original database to a different one.  If this function is a requirement you may have to go with an ODBC connection.

frodoman
0
 
Hamlet081299Author Commented:
I've tried changing one of the reports to use ODBC, but I'm still not having much luck getting it to change databases through the URL.

I've tried using both System DSNs and File DSNs, but I think I must have something wrong still.  I have two databases - one for test and one for production - "DBTest" and "DBProd".  I created system DSNs on the web server also called "DBTest" and "DBProd".

Lets say a have a report "reportx.rpt", which has been created using "DBTest", and I want to display it using "DBProd" then I am using this URL ...
reportx.rpt?user-DBProd.DBProd=sa&password-DBProd.DBProd=&promptex-TranType="ALL"

Is that correct?

H.
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
Hamlet081299Author Commented:
That won't quite work for me.  What I wanted is to have one set of reports that are reused against both a test and production database.  At any time different users will access the same report but for different databases, and I wanted to avoid having to make copies of every report and then change the connection.

If you look at ce8_urlcommands.pdf, available from ...
http://support.businessobjects.com/communityCS/TechnicalPapers/ce8_urlcommands.pdf.asp

... you will see that on page 11 it describes how to pass server name, database name, user and password via the url.  Maybe I'm mistaken but I took this to mean that I could CHANGE which database the report used.

H.
0
 
frodomanCommented:
Hamlet,

I'm very familiar with this document - unfortunately what you're looking at on page 11 is simply another way to pass the authentication credentials, it does not allow you to change the database.  That's documented here: http://support.businessobjects.com/library/kbase/articles/c2007327.asp.

Sorry, but if you're using unmanaged reports and you want to maintain both a test and production version, you'll have to maintain two separate reports (unless of course you change the ODBC as we've already discussed but that probably won't work in this situation).

frodoman
0
 
Hamlet081299Author Commented:
Not the answer I wanted to hear, but probably the only answer.

Thanks

H.
0
 
frodomanCommented:
No problem - frodoman
0
All Courses

From novice to tech pro — start learning today.