topic QV Server not interpreting connection strings in QlikView

QV Server not interpreting connection strings

Mon, 26 Jan 2026 18:19:17 GMT

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 ?

QV Server not interpreting connection strings

Thu, 17 Feb 2011 10:31:03 GMT

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.

QV Server not interpreting connection strings

prieper — Thu, 17 Feb 2011 11:35:28 GMT

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

QV Server not interpreting connection strings

Thu, 17 Feb 2011 12:41:39 GMT

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);

QV Server not interpreting connection strings

Mon, 02 May 2011 17:42:22 GMT

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

QV Server not interpreting connection strings

Denis_Brajkovic — Mon, 02 May 2011 20:00:57 GMT

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

QV Server not interpreting connection strings

Fri, 13 May 2011 16:57:31 GMT

Thanx... That was the problem!

QV Server not interpreting connection strings

Fri, 18 May 2012 07:39:57 GMT

Helped me too