-
January 5th, 2010, 04:56 AM
#1
report connecting to sql server from Linux box
Hi,
Am using Crystal Reports X and this is located in a Linux system. My report uses sql server DB.
We set up a system DSN on the Linux system that houses the Crystal Server. Am able to connect to this DSN from my Crystal Enterprise.
This is how I connect.........used the option ODBC(RDO)to create new connection. Then entered the connection string as DSN=<dsnname>;User Id=<username>;Password=<password>;
I was thus able to map the tables from the SQl Server DB and published the report to the Crystal Server in Linux system.
In the CMC, I set the DB parameters to the option - Use original database logon information from the report. But when I preview the report, it throws an error saying :
"com.crystaldecisions.report.web.viewer.CrystalReportInteractiveViewer
Failed to retrieve initial report values. For example, the database information for this report could be incomplete or incorrect. This is a configuration problem. Please contact your system administrator."
Any ideas, please help. Fix is required asap.
Thanks.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|