my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes Crystal clear report generation and JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Crystal clear report generation and JDBC" Watch "Crystal clear report generation and JDBC" New topic
Author

Crystal clear report generation and JDBC

prathamesh bandivadekar
Ranch Hand

Joined: May 22, 2008
Posts: 43
Hi there,

I was trying to generate report using i-net crystal clear report engine.

but it is giving following error,

The DB connection to "jdbcdbc:p4pdb" failed (see crystalclear.properties): [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (225)

Can anyone help to understand this?

Thanks in advance.
Romak


Prathamesh M.B.<br />Java....only.....
prathamesh bandivadekar
Ranch Hand

Joined: May 22, 2008
Posts: 43
The above connection problem is solved....but a new problem has occured...

Error sayz it like this...

Could not fetch data, reason: Report Error [0] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ;. (for the associated SQL statement: SELECT p_prep9_prep_status_semester;1.first_name,p_prep9_prep_status_semester;1.last_name,p_prep9_prep_status_semester;1.contingent,p_prep9_prep_status_semester;1.semester,p_prep9_prep_status_semester;1.semester_full,p_prep9_prep_status_semester;1.status FROM p4pdb.dbo.v_PREP9_Prep_simple_status p_prep9_prep_status_semester;1 ). has occurred after trying to run SF on db server (0)
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

can you please share your sql statement.


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Crystal clear report generation and JDBC
 
It's not a secret anymore!