Pentaho Data Integration Data Source Failed to preview the Query

Asked By Megan H Madison 0 points N/A Posted on - 03/05/2013

Hello,

When I try to use data source of Pentaho Data Integration in Pentaho BI Suite 4.5 to have a preview of some query, an error message appears. And the message says that the query could not be previewed.

Could some expert advice what I shall do to fix this error? Any solutions are welcome. Thank you very much.

Pentaho Data Integration Data Source

Failed to preview the Query.

• Status: Open
• Question Views: 780
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others

Answered By Drake Vivian 30 points N/A #175224

Pentaho Data Integration Data Source Failed to preview the Query

Hi there Megan H Madison,

The problem you're facing is a well known bug caused by badly written drivers. The problem is that the original ODBC driver doesn't work well with the JDBC-ODBC bridge.

In order to make things work you will need to look for some commercial drivers that will allow you to access the database.

Drivers that are checked and are working can be found on the following link: 

https://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html.

Best regards,
Drake Vivian

About Drake Vivian

Questions
0

Answers
820

Best Answers
186

• Vote Up 0 Vote Down

• Posted on - 03/22/2013
• Question Category: Software Others