topic Re: Data Loading from Cluster Server Environment in QlikView

Data Loading from Cluster Server Environment

sanketkhunte — Thu, 13 Mar 2014 14:41:21 GMT

Hi All,

My Source is SQL server : In which has Clustering structure. (Let say - for production we have 3 servers).

Let's define their names as below

Prod 1

Prod 2

Prod 3

I am trying to pull data from Production boxes;It Started reloading and after some time it throws ODBC Error.

(I tried it 2-3 times but could see same error)

What will be the problem.

Please provide your input on this.

Sanket

Thu, 13 Mar 2014 19:16:39 GMT

Maybe you can do a few things:

Look at the log files and see which sever pull is causing the issue
You would be having three separate connection strings for each of the servers right? So go through doc log and see also which table is causing this issue
Once you find out which server/table is causing this try some other table with that same server and see what happens
The log file should be very useful in this situation

Thanks

Thu, 13 Mar 2014 19:52:31 GMT

If you are in the domain, why not use OLE DB?

here is an example:

All you have to do is select your server name, use Windows NT, and select your database. Also, test your connection then click OK.

Robert