Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unable to test ODBC connection - Returns Error

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 1st 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

2 Replies
Not applicable
Author

Carl set the ODBC up incorrectly!

Not applicable
Author

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

www.mouchel.com <http://www.mouchel.com/