topic How to fix tables with ' - ' ?? in QlikView

How to fix tables with ' - ' ??

Mon, 22 Jun 2015 07:11:29 GMT

Hi Qlik Community,

I have a problem on loading the SQL, my friend told me that the main cause of ODBC read failed is that one of the table name has ' - ' on it. Someone help me fix this kind of error.

Thanks in advance Qlik Community

Re: How to fix tables with ' - ' ??

Kushal_Chawda — Mon, 22 Jun 2015 07:26:56 GMT

Cause of the error is some particular field from the table has some values which is not readable by QlikView

One solution could be change your connection from ODBC to OLEDB. If still it's not working then you have to check manually field by field to know which field has issue.

Instead of Select * , load all the field names in select and comment some field randomly

Re: How to fix tables with ' - ' ??

Mon, 22 Jun 2015 07:48:34 GMT

Hi Kush,

Sir this what happen when I conned to OLE DB

Re: How to fix tables with ' - ' ??

Peter_Cammaert — Mon, 22 Jun 2015 07:55:45 GMT

Check the spelling of your database name in the CONNECT string. Case should match.

See also knowledgebase.progress.com/articles/Article/7340 (link removed because of moderation, copy link into yuur browsers address bar).

Peter

Re: How to fix tables with ' - ' ??

Tue, 30 Jun 2015 06:13:47 GMT

I just fix it using dbtool