topic Error: ODBC read failed in QlikView

Error: ODBC read failed

Sun, 24 Feb 2013 12:22:25 GMT

While loading the access database(ODBC connection) I got the following error:

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 4294966090, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

I extracted a fresh copy of the database and tried again, but even then the same error pops up.

How to solve this?

Re: Error: ODBC read failed

Sun, 24 Feb 2013 18:04:39 GMT

Some ideas...

http://community.qlik.com/thread/38196

http://community.qlik.com/message/302850

Re: Error: ODBC read failed

phaneendra_kunc — Sun, 24 Feb 2013 18:47:10 GMT

Have you tried OLEDB connection instead of ODBC?

Re: Error: ODBC read failed

Tue, 26 Feb 2013 05:20:22 GMT

No have not tried... But when I commented a field with memo datatype it seemed to work fine. But I need that field.. What to do?

Re: Error: ODBC read failed

Tue, 26 Feb 2013 12:55:39 GMT

The memo field should work fine with an ODBC connection. But it could always be an issue with your particular ODBC driver, and of course I've not tested across versions, etc.

If the memo field is the only column that consistently causes the load to fail, perhaps you can string converting the type to string. You could do this by calling CStr() in your SELECT (again, assuming you are using ODBC against MS-Access), so something like this:

SQL SELECT

CStr(MyMemoField) As MyField

FROM Table1;

Or you could do this in your MS-Access database as a query, then just SELECT the query instead of the table.