topic Re: .aacd loading to Acess Point getting error in QlikView

.aacd loading to Acess Point getting error

tsoley9262 — Mon, 26 Jan 2026 18:19:17 GMT

I have an access database (accdb) I can load local but when I try to load on Access Point I am getting this error in my log file:

2019-07-18 07:52:05 Error: Connector connect error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2019-07-18 07:52:05 Connector connect error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Re: .aacd loading to Acess Point getting error

Chip_Matejowsky — Thu, 18 Jul 2019 16:07:27 GMT

Hi @tsoley9262,

There are two likely reasons for this error:

Data Source Name (DSN) isn't configured or available
Database driver used in the DSN hasn't been installed or potentially corrupted

Have you configured the necessary DSN and installed db driver? Have a look at the Qlik Support article "Reload fails with error "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"" to see if it helps you resolve the issue.

Re: .aacd loading to Acess Point getting error

tsoley9262 — Thu, 18 Jul 2019 17:07:46 GMT

~~Thanks Chip I will look into~~

Re: .aacd loading to Acess Point getting error

Brett_Bleess — Tue, 13 Aug 2019 18:05:16 GMT

Hey Thomas, did Chip's post get you sorted out? If so, please be sure to click the Accept as Solution button to let others know this worked. If you are still working on things, please leave us an update of where things stand, so we can try to offer other ideas.

The other thing to realize on these issues, when the ODBC/OLE DB connections return errors, it is generally the connector returning the error, not QlikView, we are simply dumping the message the connect gave back to us and generally the connector is provided by the DB vendor, so doing a search on the DB vendor site can also provide useful information in these cases...

Regards,
Brett