Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-02-25 12:55 AM

Memo access db field error in qlikview

Hi,

I have a mandatory field called History(memo datatype) in an access database and it shoots an error while loading the table to Qlikview.

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 have the latest copy of a working database and  assume it is due to the large size of data residing in that particular field per row (being a memo datatype).I am currently using an ODBC connection.Any ideas how to go about with this issue?

Any help would be highly appreciated.I am a newbie to Qlikcommunity.Thanks alot.

Regards,

Naima

1,167 Views
0 Likes
0 Replies