topic Re: fail to use ODBC in QlikView

fail to use ODBC

ericmkyeung — Fri, 03 Dec 2021 03:09:47 GMT

Would like to use SQL load in QV (Ver 12) but nothing to show after click 'ODBC' connect button even force 32bit.

please help~

I added User DSN already:

none of User DSN can be show:

Re: fail to use ODBC

marcus_sommer — Fri, 03 Dec 2021 08:24:27 GMT

Did it work before with an older release? Or for another user? Any changes in regard to the OS?

If it's the first attempt to use an ODBC I wouldn't be surprised if there isn't the wanted ODBC driver installed. That you see entries within ODBC manager doesn't mean mandatory that they are really installed, for example a current MS Office installation doesn't installed the ODBC driver (AFAIK unless it's a msi-package installation). In this case you will need to install the ODBC afterwards.

- Marcus

Re: fail to use ODBC

ericmkyeung — Mon, 06 Dec 2021 02:12:33 GMT

Thanks Marcus.

it works before and i think the driver has been installed. any idea i can double check? many thanks!

Re: fail to use ODBC

marcus_sommer — Mon, 06 Dec 2021 08:39:20 GMT

You mean in QV11 it worked on the same machine, the same OS and the same Users and after the QlikView upgrade to QV 12 it didn't work anymore? What happens if you tries to run an query with an older connection-string respectively to use it for a new query - bypassing on this way the wizard?

- Marcus