topic Unable to test ODBC connection - Returns Error in QlikView

Unable to test ODBC connection - Returns Error

Fri, 03 Feb 2012 07:52:45 GMT

We have created an application where we have residing on site a Data Collector application which creates the QVD files which in turn are sent via secure Ftp to our data centre where the QVD’s are loaded into our QlikView application.

This is has been successfully installed on a number of sites, however on one particular site I get the following connection error even though my ODBC settings are correct and can connect to the Data Source.

This is the 1^st time we have ever encountered this error, Do anyone know what port this uses? Is it just the standard SQL Port of 1433 or something different? . We are using the x64 version of QlikView Personal Edition SR7. Any assistance that you could offer would be gratefully received

The error being returned is "Test connection failed because of an error in initalising provider. Unsecified error"

As you can see typical informative Microsoft error

Unable to test ODBC connection - Returns Error

Thu, 23 Feb 2012 20:59:55 GMT

Carl set the ODBC up incorrectly!

Re: Unable to test ODBC connection - Returns Error

Thu, 23 Feb 2012 21:18:28 GMT

Yep, he has mate, how are things

Regards

Jim Holden

Business Intelligence Analyst | Technology

Mouchel, 3rd Floor Mercury Court, Tithebarn Street, Liverpool L2 2QP

M +44 (0)781 259 3415 | E jim.holden@trafficsupportmp.com <mailto:jim.holden@trafficsupportmp.com>

passion for success | spirit of adventure | integrity at heart