topic Re: Does Qlikview ODBC write access for all DB ? in QlikView

Does Qlikview ODBC write access for all DB ?

bkkuah17 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Currently I trying perform insertion into database and found not all database's ODBC can perform insert statement. While the

same script works in MySQL at the same time it doesn't work with Netezza. Is there additional setting can be done or it is Qlikview limitation or licensing issue ?

Configuration done,

Qlikview ODBC drive allow read access, whereas Windows setting allows read/write access.

ODBC log tracers show errors occurs at access write issue,

Thanks

Re: Does Qlikview ODBC write access for all DB ?

marcus_sommer — Thu, 22 Jun 2017 11:51:12 GMT

I think the limitation is within your used odbc-driver and/or you haven't the appropriate user-credentials and/or the db security-settings are restricting to the write-access in any way.

- Marcus

Re: Does Qlikview ODBC write access for all DB ?

bkkuah17 — Thu, 22 Jun 2017 23:37:41 GMT

As the screenshot shows windows registry is granting read write acces, while qlikview is granting only read access. Windows ODBC log tracer shows the session was opened with a read access to execute scripts.

I am successfully execute the same script in Aginity Workbench with the same login access.

With the same ODBC connection in Qlikview I only manage to view records in the table.

Re: Does Qlikview ODBC write access for all DB ?

marcus_sommer — Fri, 23 Jun 2017 05:16:05 GMT

I don't think that's on the qlikview-side because the same worked with MySQL which proved the general working of your approach and AFAIK qlik has no further part as to transfer the sql-statement to the database-driver and to get data back (in case of a select-statement). This meant there must be another reason. Are you sure that there is no write-lock on that table when you tried to write the data?

- Marcus