Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mmortsie1
Contributor II
Contributor II

Qlik ODBC Connector problem

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.

11 Replies
ashfaq_haseeb
Champion III
Champion III

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
Partner - Specialist II
Partner - Specialist II

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
Contributor II
Contributor II
Author

Hallo,

Changing it to 60 seconds did not help this still happens

Not applicable

Hi Manoj,

How do I go about changing the QueryTimeout Value?

Thanks

cheburashka
Creator III
Creator III

Hi Markus,

Did you figure out how to solve this problem?

, Thanks for sharing, KR Koen

cheburashka
Creator III
Creator III

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
Partner - Contributor
Partner - Contributor

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
Contributor III
Contributor III

Markus,

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

Thanks

Nate

mmortsie1
Contributor II
Contributor II
Author

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