Qlik ODBC Connector problem

[mmortsie1]

Hallo,

Im using the new Qlik ODBC Connector and i keep geting Timeout issues.After just a few seconds  ERROR [HYT00] [Qlik][ODBC Oracle Wire Protocol driver]Timeout expired.

Here is my ODBC Connection String

CUSTOM CONNECT TO 'Provider=QvOdbcConnectorPackage.exe;driver=oracle;host=AAA.com;port=1521;servicename=AAA;Connection Timeout=0;EnableNcharSupport=1;XUserId=AAA;XPassword=AAA;';

Does anyone have an idea what the cause it.

[ashfaq_haseeb]

Hi,

Try by changing timout to 60 and let me know if that worked.

CUSTOM CONNECT TO 'Provider=QvOdbcConnectorPackage.exe;driver=oracle;host=AAA.com;port=1521;servicename=AAA;Connection Timeout=60;EnableNcharSupport=1;XUserId=AAA;XPassword=AAA;';

Regards

ASHFAQ

[manojkulkarni]

If a longer timeout period is needed, increase the value of the QueryTimeout connection attribute or SQLSetStmtAttr(SQL_ATTR_QUERY_TIMEOUT)setting.

Valid values are -1 | 0 | x where x is a positive integer that specifies a number of seconds.

If set to -1, the query does not time out. The driver silently ignores the SQL_ATTR_QUERY_TIMEOUT attribute.
If set to 0, the query does not time out, but the driver responds to the SQL_ATTR_QUERY_TIMEOUT attribute.
If set to x, all queries time out after the specified number of seconds unless the application overrides this value by setting the SQL_ATTR_QUERY_TIMEOUT attribute.

Default is 0

[mmortsie1]

Hallo,

Changing it to 60 seconds did not help this still happens

[#5]

Hi Manoj,

How do I go about changing the QueryTimeout Value?

Thanks

[cheburashka]

Hi Markus,

Did you figure out how to solve this problem?

, Thanks for sharing, KR Koen

[cheburashka]

Hi Kevin,

Did you find a settings file for the Qlik ODBC Connector where you could change this setting?

,Thanks for sharing, Koen

[jean-marc]

dear Koen,

for me, it is just a test today, il will see tomorrow,

i add in my connection 2 parameters:

CUSTOM CONNECT TO "Provider=QvOdbcConnectorPackage.exe;driver=oracle;host=ADR_IP;port=1521;servicename=SERVICE_NAME;Connection Timeout=60;SQL_ATTR_LOGIN_TIMEOUT=60;EnableNcharSupport=1;XUserId=....

It seem to work.

jm

[nategreen]

Markus,

Did you ever figure out the solve for this? I am having the same issue, too.

Thanks

Nate

[mmortsie1]

Hello,

No never got it to work. I installed the Oracle 11 Drivers Directly onto the server to solve the time out problems

Regards

Markus