Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

QV Server not interpreting connection strings

I have designed some models that work fine and can reload perfectly when reloaded manually in QV. However when I move these models to the server the server is unable to run reloads on them.

Looking at the logs the server reload seems to fail when it reaches mention of a connection string - whether it be ODBC or OLE.

Could there be a bug or corruption of something on the server (v10) ? It can not be a corruption of MDAC or the MySQL ODBC drivers I am using because when running manually the connections are made perfectly...

I'm totally stumped and I'd prefer to not have to reinstall the whole QV server and QV enterprise software package. Perhaps there is a way to check the install ?

1 Solution

Accepted Solutions
dbc
New Contributor III

QV Server not interpreting connection strings

First, check that the ODBC is a System DSN. If not, then it won't work.

Second, log in on the server with the same user as you run the QV services. Make a manual reload from QV Developer. At this stage it will most probably fail (and most probably because it's not a System DSN driver)

Hope this helps

7 Replies
Not applicable

QV Server not interpreting connection strings

I have now set up a separate server and run the same models on that. They run fine there so it must be some kind of config or corruption issue on the initial server.

prieper
Honored Contributor II

QV Server not interpreting connection strings

Have you checked that the names of the ODBC-connections are identical on your local system and on the server?
Alternativelz difference might be caused by different drivers avail for 32- and 64-bit versions on the server.

HTH
Peter

Not applicable

QV Server not interpreting connection strings

Yes, as mentioned I can set the model up directly on the server and make manual connections to the data sources. I have even recreated the connection strings on the server inside the models and can test connection succesfully and also manually reload successfully. As soon as I try to reload the model via a server task it fails.

It can not be a driver issue because of this.

This is the error in the log file:


Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Even though the data source is clearly stated in the script: (And works when manual reloading)

ODBC CONNECT TO [Ubuntu MySQL] (XUserId is KRIEaWVOMDdSWWFMULaGWZJT, XPassword is fbXEcTVILbaeGXcGWBLA);

Not applicable

QV Server not interpreting connection strings

Did you get the solution for this issue? i have the same problem..

dbc
New Contributor III

QV Server not interpreting connection strings

First, check that the ODBC is a System DSN. If not, then it won't work.

Second, log in on the server with the same user as you run the QV services. Make a manual reload from QV Developer. At this stage it will most probably fail (and most probably because it's not a System DSN driver)

Hope this helps

Not applicable

QV Server not interpreting connection strings

Thanx... That was the problem!

Not applicable

QV Server not interpreting connection strings

Helped me too