This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
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 Elasticsearch in Action this week in the Big Data 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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Crystal clear report generation and JDBC