We are trying to connect to a Pervasive Database, but apparently don't have the correct ODBC drivers. We have an older version of Pervasive, but are getting an 'appcrash' error when connecting. Qlikview Support says we need the most current version of the ODBC drivers. Our contact with Pervasive is difficult to reach, so I thought I'd check here to see if anyone can send me the ODBC connections they are using and working successfully with QV 11.2. If anyone can help out, I'd greatly appreciate it!! Thanks~Rebecca
I had read that on QV forums to install 32 bit drivers for PSQL. I tried installing 64 bit drivers after working through 32 bit drivers to check if they work. But doesn’t apparently. So that’s out of question.
Also 32 bit drivers, I checked and they are running from correct target location: %windir%\SysWOW64\odbcad32.exe (as also suggested in forum).
When we query PSQL database from MS Access/Excel using these same ODBC connections, it works and we can retrieve the data. But when we try to run a query from QV Desktop app tool, we get errors. Even the simple Select statement queries do not run and gives us Architecture difference errors.
Ours seems to be working now. Occassionally we get a fail due to null value. Have not figured that one out yet but it is not consistent. I have to check everyday until the set up a mail server on the QV server so we can get emailed alerts