CE10 Will Not Connect to Progress db

[mwake]

I am presently upgrading from Seagate Info 7 to CE10. Most of the reports in SI have multiple data sources, including a SQL Server data warehouse and also multiple Progress db's. The ODBC connections for the Progress dbs using the Progress 3.7 drivers do not utilize security and do not use a user name or password. When I try to run a report with a single Progress data source, I get an error indicating that my logon parameters are either incomplete or incorrect. The drivers on the new server with CE are configured the same way as previously described. The report runs OK in CR10, but not in CE. I tried setting up a test db, turned on security and used a userid and password, and again the report ran OK in CR10 but not CE 10.

Anyone have an idea as to why the Progress drivers work with CR10 and not CE10??

 

[Turkbear]

Hi,
Usually caused by a file system/OS permissions issue involving the account that the CE services ( servers) run under
Be sure that account has the needed permissions to the location of the database.

It is the account used by the services that 'actually' accesses the data, not the user who may be running the report.





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

 

[paulmarr]

Try downloading an article entitled:
"Getting Started with Crystal 9 and Progress SQL-92" from:

http://psdn.progress.com/library/white_papers/reporting/index.ssp

Cheers
paulmarr