INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Error Failed to open connection crweb00000119 when running a report with a Parameter

Error Failed to open connection crweb00000119 when running a report with a Parameter

Error Failed to open connection crweb00000119 when running a report with a Parameter

(OP)
I have created a report in Crystal 2011 getting data from a SQL server, and then place it on the CE server.

The report runs fine in Crystal Reports, and runs fine on CE. However when I change the report and add a Parameter it the falls over with the error in the subject.

Any ideas would be gratefully received.

Regards
Lee

RE: Error Failed to open connection crweb00000119 when running a report with a Parameter

Which version of CE? Are you using Crystal 2011 or Crystal XI? There is no guarantee that reports created in Crystal 2011, which is fairly new, will work with any version of CE, which is old software.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

RE: Error Failed to open connection crweb00000119 when running a report with a Parameter

(OP)
When I look in the About it says version 14. It was bought this year.

Any way I found a fix. The ODBC connection on my machine was spelt with a capital letter ie 'Connection' and the one on the CE machine was lower case 'connection'. So I changed mine to 'connection' and it works.

I just don't believe that makes a difference.

Thanks
Lee

RE: Error Failed to open connection crweb00000119 when running a report with a Parameter

Yes, version 14 is Crystal 2011. You'll need to be careful about which functionality you use in this version Crystal - if you use functionality that's new since CE 10 came out, it will not run correctly in CE 10. If you do a Google search on "Crystal reports 2011 version comparison", the first non-sponsored link in the list goes to a pdf title "Comparison of Features by Version for the SAP Crystal Reports". This should show you which features are compatible with Crystal 10, which is the version that came out with CE 10.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

RE: Error Failed to open connection crweb00000119 when running a report with a Parameter

(OP)
Thanks, I'll keep that close by. First time on a CE server.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close