Read Fields from ODBC Data Source

0

Hi community,

My reports uses JDBC connection that connect to ODBC data source and I've created ODBC DSN which connect to CSV file.

The JDBC connection is successfully connected...And I use SQL statement in iReport Designer for reading fields from CSV file, but I got an error.

Can you help me to fix this error? I appreciate your help.

 

Ranit's picture
21
Joined: Nov 13 2012 - 6:51pm
Last seen: 7 years 6 months ago

2 Answers:

0

Can you give the detailed error ?

sujitpgouda's picture
Joined: Jul 20 2013 - 3:59am
Last seen: 7 years 7 months ago
0
Attachments: 
AttachmentSize
Binary Data phpkkfavd59.14 KB
Ranit's picture
21
Joined: Nov 13 2012 - 6:51pm
Last seen: 7 years 6 months ago

Hi sujitpgouda ,
I uploaded the image above.

When I pressed Read Fields button,it said that:

Error: General problem: Error preparing statement for executing the report query: SELECT csv_data_csv.`ID`,csv_data_csv.`NAME`,csv_data_csv.`SEX` FROM `csv_data`.`csv` csv_data_csv Check username and password; is the DBMS active?

What's the problem?Thanks.

Ranit - 7 years 8 months ago
Feedback
randomness