Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV reload ODBC connect does not work in QV Server

Hello,

Our customer uses an MSAccess database on server A and Qlikview Server is installed on server B. When we reload QVW within local QV desktop application on QV server, ODBC connection works and data is reloaded. When we do the same with a scheduled reload task in QV Server (tried 32- and 64-bit), the reload stops at ODBC Connect. All is tested with the same domain user account (which works for local QV desktop application).

Please help.

Kind regards,

Patrick Strooij - Provelu

FYI: server with Access dbase is Windows 2003 x32 R2 Std and QV server is Win2008 x64 R2 Std

4 Replies
Not applicable
Author

I presume you've installed and set up the ODBC drivers on the QV server ?

Not applicable
Author

In addition to what Graeme has stated, your problem is likely due to the there being no 64 bit access (jet) drivers in existance (your QV server's OS architecture is the one that defines which odbc drivers are used)

There has been limited success by compiling a DSN using the 32 bit odbc admin on the QV server (see link) but the offical line from microsoft is that access/jet connections are not supported via a 64bit OS. A more robust solution is to load the database on a 32 bit SQL server and use access as a front end.

http://support.microsoft.com/kb/942976

Bill_Britt
Former Employee
Former Employee

Office 10 now has x64 ODBC for access. You would have to install that on the server.

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
ivan_will
Partner - Creator II
Partner - Creator II

I installed it, but the same situation!!

instead of the 4.0  jet provider using the 12 provider

What to do?