Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

i have loaded a .mdb file through oledb connector ?

when i  go for reload it gives error ?

i am not woryying about error

my question is even i have used oledb but when i for reload it is giving ODBC failed

why it is telling odbc ? i have used oledb

1 Reply
petter
Partner - Champion III
Partner - Champion III

The short answer: Your OLE DB driver use an ODBC driver to access the Microsoft Access .mdb file.

An OLE DB driver can be a wrapper for an ODBC driver. That means that it is essentially using an ODBC driver under the hoods to connect to and use the database. It can be a layered architecture. A lot of OLE DB drivers are not using ODBC to do their work. OLE DB allows you to connect to non-relational / non-SQL oriented data sources. ODBC is restricted to table-oriented sources unless the driver tries to mimic table-orientation where there is none.

The ODBC-driver that the OLE DB-driver is using is giving you an error message. Microsoft has something they call "Microsoft OLE DB provider for ODBC".