Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted

Re: Connection string Timeout - is it possible?

Can you add some trace commands after the connect string to see exactly where the error is?

Can you run a ping to the SQL box to see if the network connection drops.

Highlighted
thenextlevel
New Contributor II

Re: Connection string Timeout - is it possible?

I'll have a look.

I've found this which might help.

Data server is not available. How to exit script without error?

Highlighted
Not applicable

Re: Connection string Timeout - is it possible?

Hello,

We are also facing similar issue while connecting SQL server from Qlikview dashboard.

We are getting error like below when Qlikview trying to connect sql server from script window,

Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login timeout expired

This is a random issue that we can't replicate unless it happens. some times it auto resolved and again happens with out making any change in code or configuration on sql server.


Can you help to find exact root cause of this behavior ?


Thanks,

Highlighted
ejk_citi
New Contributor II

Re: Connection string Timeout - is it possible?

We have a similar need for a timeout here as well. 

I've got connection attempts that are hanging open when the database accepts the old credentials, but then prompts for a password change.


Does setting a document timeout in the reload task force this to move on from waiting around?