Click here to Skip to main content
Rate this: bad
good
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 at 13-Mar-13 3:43am
   
Please share code how you are sharing/setting db connection to Crystal report.
Tmuzvidzwa at 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 at 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
0 OriginalGriff 381
1 Praneet Nadkar 237
2 Marcin Kozub 225
3 Sergey Alexandrovich Kryukov 200
4 Shweta N Mishra 161
0 OriginalGriff 8,284
1 Sergey Alexandrovich Kryukov 7,327
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,920


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 14 Mar 2013
Copyright © CodeProject, 1999-2014
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