How? ASP/Crystal Reports 10/Oracle 9i stored procedure
Hi,
I need to run a report with an Oracle 9i stored procedure backend, from ASP.
The report works fine.
Am I overlooking something? The fundamentals of this question have been asked many times before. However, I need a DSN-less solution.
Ideally I'd like:
1. Basic crystal report (not essential as I could generate a report manually).
2. Script to create the stored procedure and any tables.
3. ASP code to run the report (Im assuming most of the code will be in the examples such as aspxmps10, aspxmps11 & aspxmps115)
I've looked at the examples and can run the "BeginHere" example, but I cannot find anything valid which connects to a (real) database.
I'm using an Oracle Server (ie DSN-less) connection to Oracle from crystal reports.
Thx.
I need to run a report with an Oracle 9i stored procedure backend, from ASP.
The report works fine.
Am I overlooking something? The fundamentals of this question have been asked many times before. However, I need a DSN-less solution.
Ideally I'd like:
1. Basic crystal report (not essential as I could generate a report manually).
2. Script to create the stored procedure and any tables.
3. ASP code to run the report (Im assuming most of the code will be in the examples such as aspxmps10, aspxmps11 & aspxmps115)
I've looked at the examples and can run the "BeginHere" example, but I cannot find anything valid which connects to a (real) database.
I'm using an Oracle Server (ie DSN-less) connection to Oracle from crystal reports.
Thx.
sorry kev1970... but what to you want to know from us? since you said the report works fine...
if you want a DSNless connection, just create an Oracle OLEDB connection using below connection string
"Provider=OraOLEDB.Oracle.
dylan
if you want a DSNless connection, just create an Oracle OLEDB connection using below connection string
"Provider=OraOLEDB.Oracle.
dylan
What data source did you use to create the report?
mlmcc
mlmcc
ASKER
Original problem rephrased:
My report works fine in crystal reports (ie cr developer 10 & 11) and crystal enterprise 10 and has data from an Oracle 9i stored procedure (with 5 IN parameters,and 1 OUT parameter(the REF CURSOR)).
How do I run this report from ASP?
Can someone could give me an appropriate example?
I would need, at least:
1. A crystal report (not essential as I could generate a report manually).
2. A script to create the stored procedure and any tables.
3. ASP code to run the report (Im assuming most of the code will be in the examples such as aspxmps10, aspxmps11 & aspxmps115)
My report works fine in crystal reports (ie cr developer 10 & 11) and crystal enterprise 10 and has data from an Oracle 9i stored procedure (with 5 IN parameters,and 1 OUT parameter(the REF CURSOR)).
How do I run this report from ASP?
Can someone could give me an appropriate example?
I would need, at least:
1. A crystal report (not essential as I could generate a report manually).
2. A script to create the stored procedure and any tables.
3. ASP code to run the report (Im assuming most of the code will be in the examples such as aspxmps10, aspxmps11 & aspxmps115)
Again, what data source did you use to create the report? If you used a DSN then you are stuck with using a DSN for the application.
Here are some ASP examples
http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps10.exe.asp
mlmcc
Here are some ASP examples
http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps10.exe.asp
mlmcc
ASKER
mlmcc,
I repeat,
"...3. ASP code to run the report (Im assuming most of the code will be in the examples such as aspxmps10, aspxmps11 & aspxmps115)
I've looked at the examples and can run the "BeginHere" example, but I cannot find anything valid which connects to a (real) database.
I'm using an Oracle Server (ie DSN-less) connection to Oracle from crystal reports..."
This problem has surprised me because I thought a lot a crystal reports/oracle users would've had the same problem and resolved it.
Which example in aspxmps10.exe do you think will help?
I repeat,
"...3. ASP code to run the report (Im assuming most of the code will be in the examples such as aspxmps10, aspxmps11 & aspxmps115)
I've looked at the examples and can run the "BeginHere" example, but I cannot find anything valid which connects to a (real) database.
I'm using an Oracle Server (ie DSN-less) connection to Oracle from crystal reports..."
This problem has surprised me because I thought a lot a crystal reports/oracle users would've had the same problem and resolved it.
Which example in aspxmps10.exe do you think will help?
Sorry. Not familiar enough with the ASP methods to really help.
I suspect the
SimpleSetLogonInfo or SimpleTableLocation
mlmcc
I suspect the
SimpleSetLogonInfo or SimpleTableLocation
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Does that solve the problem?
mlmcc
mlmcc
ASKER
Yes, although altered slightly, for security reasons, the above code runs my crystal 10 report in IE6.
I'm, also, running the crystal reports 10 developer edition & IIS on my machine (W2k).
I'm, also, running the crystal reports 10 developer edition & IIS on my machine (W2k).
You say you already have the report. What do you need for this?
>>2. Script to create the stored procedure and any tables.
This should be done in the database.
>>3. ASP code to run the report (Im assuming most of the code will be in the examples such as aspxmps10, aspxmps11 & aspxmps115)
If the report was built against the database and you aren't changing that hten there is no need to pass connection information. Eliminate that from the code.
mlmcc