topic Re: Qlikview ODBC Connector Timeout Error in QlikView

Qlikview ODBC Connector Timeout Error

Fri, 02 Oct 2015 03:45:15 GMT

Hi,

I am getting a Timeout Error using the new Qlikview ODBC Connector for Oracle. How do I change these values? I've tried inputting "QueryTimeout" in the Advanced section but it has not changed a thing.

note: If i use the native oracle driver on another machine using the same sql, it does not come up with a timeout error.

Thanks,

Kevin

Re: Qlikview ODBC Connector Timeout Error

marcus_sommer — Fri, 02 Oct 2015 12:32:38 GMT

I think this will be caused by the odbc-settings within the oracle which could be quite different to their own driver.

- Marcus

Re: Qlikview ODBC Connector Timeout Error

Mon, 05 Oct 2015 22:35:05 GMT

Thanks Marcus,

I thought that too but If i use the oracle driver, I don't get this timeout error. In any case, how can I change the timeout settings for the oracle driver settings (and/or the Qv ODBC connector settings).

Regards,

Kev

Re: Qlikview ODBC Connector Timeout Error

marcus_sommer — Tue, 06 Oct 2015 06:47:18 GMT

I don't work with oracle but I think the oracle-driver is a very specialized piece of connection, very optimized to an oracle-environment and far away from a quite old odbc-standard which needs very general.

This should be helpful: https://support.microsoft.com/en-en/kb/251248 and more general: Google.

- Marcus

Re: Qlikview ODBC Connector Timeout Error

marcus_sommer — Wed, 07 Oct 2015 11:56:35 GMT

Here are two further links which might be helpful:

Installing Oracle OLEDB Drivers.docx

Connectivity to Oracle Database

- Marcus