topic Re: Pervasive ODBC drivers? in QlikView

Pervasive ODBC drivers?

Thu, 29 Aug 2013 20:16:04 GMT

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

Re: Pervasive ODBC drivers?

Siva_Sankar — Fri, 30 Aug 2013 05:02:50 GMT

http://community.qlik.com/message/22682#22682

Re: Pervasive ODBC drivers?

Fri, 30 Aug 2013 19:01:19 GMT

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.

Re: Pervasive ODBC drivers?

Mon, 21 Oct 2013 02:24:03 GMT

Rebecca,

Did you find a solution?

Having similar problems ODBC connection working in XL, but not in QV.

Re: Pervasive ODBC drivers?

Wed, 23 Oct 2013 15:43:53 GMT

No, we did not get a solution. We were told that Qlikview no longer supports the Pervasive ODBC drivers. We had to use a completely alternate route to get the data into Qlikview.

Let me know if you have any questions.

Thanks~RR

Re: Pervasive ODBC drivers?

harvinderjohal — Mon, 06 Jan 2014 22:04:27 GMT

Hi Rebecca,

Curious if you can share what the alternate path that you used was to pull data from Pervasive into QlikView?

Harvey

Re: Pervasive ODBC drivers?

Mon, 03 Feb 2014 17:28:49 GMT

I have a client using Peachtree. They mentioned it is PSQL, will they have the same issues?

Re: Pervasive ODBC drivers?

felixobes — Sat, 08 Feb 2014 14:28:30 GMT

Seems so. I see that the conversation on thread ODBC drivers for PERVASIVE DB did not yield a result yet.

Anyone had a good experience pulling from Pervasive or is the effort not worthwhile and suggest raw csv exports?

Re: Pervasive ODBC drivers?

Fri, 14 Feb 2014 17:09:59 GMT

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

Re: Pervasive ODBC drivers?

felixobes — Wed, 19 Feb 2014 02:48:50 GMT

Well, I did manage to get the data in. Had to setup an ODBC Pervasive driver but 32 bit. The thing is that I am only being able to get data from one table at a time. Not multiple. Yet.

The driver I got was the trial one from Progress. It's the ODBC Direct Data Connect 7.1.2.

I still have not tried others, but I heard theirs was fast.

Re: Pervasive ODBC drivers?

aldo-tgh — Mon, 01 Sep 2014 14:55:30 GMT

Hi Rebecca,

I understand you successfully connect to Pervasive database?

Could please share a step by step how to do it?

Thanks in advance,

Aldo.