Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Lets see if anyone has some input on this one. I have scheduled a reload of 3 qvw's every morning. Two of them keeps on failing at scheduled time, where as one works fine. The error message I get is in the log file:
Error: SQL##f - SqlState: 08001, ErrorCode: 17, ErrorMsg: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
Thing is that I can reload the qvw manually from the QMC by clicking the playbutton and it will always run succesfully.
See.
I can't get my head around I have updated the ODBC connection they all run 64bit no one i forcing 32 bits.
Are you connecting to the SQL server using a SQL account or windows authentication?
If windows authentication, does the QlikView Distribution Service account user have permissions to the SQL database?
Is the SQL server local or remote? If remote is there a timeout when trying to connect.
Are the reloads all running at the same time? Can you set them to run sequentially?
I am remoting to a computer that is running qlikview server. Thing is that some of them work and soem deosnt so I cant find a distinct problem if you understand what I mean..