Click here to Skip to main content
13,193,405 members (57,617 online)
Rate this:
Please Sign up or sign in to vote.
Failed to open the connection. Details: Database vendor code 17. This is the error am getting when try to generate crystal reports. In the same project, i can do other operations on the same database like insert, update, delete and select. Just can not generate the reports. However on the development machine, i can view the reports.

I am using Visual Studio 2010, C#, and crystal reports
Posted 12-Mar-13 21:18pm
Updated 12-Mar-13 21:44pm
ssure1singh 13-Mar-13 3:43am
Please share code how you are sharing/setting db connection to Crystal report.
Tmuzvidzwa 13-Mar-13 3:46am
as for this i did not write any code: just dropped the report viewer on the page and selected a crystal report using wizard and it gets the database fields
supriya chaladi 13-Mar-13 6:31am
right click on crystal report
goto database
open show sql query
select that query and check whether ur getting data for that query.
I guess table were not linked properly.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I fixed it. Since the problem was with connectivity, i put in a custom user in the application pool's identity problem solved.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.171017.2 | Last Updated 14 Mar 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100