How to fix tables with ' - ' ??

[#1]

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

[Kushal_Chawda]

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

[#3]

Hi Kush,

Sir this what happen when I conned to OLE DB

[Peter_Cammaert]

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

[#5 · Accepted solution]

I just fix it using dbtool