Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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".