Click here to Skip to main content
12,069,894 members (66,557 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#, ASP.net and crystal reports
Posted 12-Mar-13 22:18pm
Edited 12-Mar-13 22:44pm
v3
Comments
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
 
good
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.
  Permalink  

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 | Mobile
Web04 | 2.8.160208.1 | Last Updated 14 Mar 2013
Copyright © CodeProject, 1999-2016
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