Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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