Not able to generate reports from Web

[vpk123]

I created the reports using oracle and crystal reports 10

i used odbc driver for oracle for connetivity.

Reports are coming without any problem if i generate from crystal reports, but i tried to generate same from web, i am getting error,

if i use odbc for windows i am able to do without any problem

can any body help in this

 

[Turkbear]

Hi,
Please explain further:

How are you trying to run from the web?

There is no such thing as an ODBC for Windows , so what driver do you mean?

What error?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Never heard of ODBC for Windows, I think that you're confusing terms here. And you should understand that the ODBC driver for Oracle supplied by Oracle should never be used, you need to use the Oracle ODBC driver supplied by Crystal.

I suggest that you switch your reports to use the Oracle native connectivity (shown as Oracle Server), then you won't suffer the slower response of ODBC, and won't need to set up the same ODBC connection on your report server, which may be your only problem here.

-k

 

[vpk123]

I am using CR 10 version,
i created report and able to generate with out any problem,

i saved a report with option save as in enterprise for webaccess,
and trying to generate report from web , report generation getting failed and getting the below error.


Status: Failed
Printer: The instance is not printed.
External Destination: None
Creation Time: 4/26/2006 10:31:42 AM
Start Time: 4/26/2006 10:31:44 AM
End Time: 4/26/2006 10:32:09 AM
Server Used: jacausyweb1.reportjobserver
Error Message: Unable to connect: incorrect log on parameters. File C:\Program Files\Crystal Decisions\Enterprise 10\Data\procSched\jacausyweb1.reportjobserver\~tmp228c44704db8550.rpt.

 

[Turkbear]

Hi,
You need to set the Database login info for that report in the CMC and be sure to uncheck the 'prompt user for Login' option..




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

I wasn't saying that you can't use the Oracle supplied ODBC driver, I'm stating that it might occasionally return bad data.

Turk covered the method for setting the database within CE, and you also need the same ODBC setup on the server.

Note that if you have parmaeters, you need to set those as well and make sure you clikc update, many people miss that.

-k

 

[vpk123]

I tried the above option, still am getting the following error

Status: Failed
Printer: The instance is not printed.
External Destination: None
Creation Time: 5/1/2006 7:57:59 AM
Start Time: 5/1/2006 7:58:01 AM
End Time: 5/1/2006 7:58:18 AM
Server Used: jacausyweb1.reportjobserver
Error Message: Unable to connect: incorrect log on parameters. File C:\Program Files\Crystal Decisions\Enterprise 10\Data\procSched\jacausyweb1.reportjobserver\~tmpcc4448980bb410.rpt.