Discussion Board for collaboration on QlikView Scripting.
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.
I'll have a look.
I've found this which might help.
Data server is not available. How to exit script without error?
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 ?
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?