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: 
Anonymous
Not applicable

Pervasive ODBC works manually but not on server

All,

I am attempting to pull data out of Pervasive DB (Sage Platinum for Windows) and it works well enough when running on the desktop.  But when publisher, the ODBC connection is failing.  The pub is on the same machine as the desktop and I using the service account to develop so that can't be the issue.

Has anyone had experience with this and why would there possibly by a difference in this case between running the script on the desktop vs the server considering it is same machine and same user?

Any ideas would help.

Regards,

Aaron

9 Replies
johnh
Partner - Creator
Partner - Creator

Hi Aaron,

Did you manage to get this to work. I have a similar issue?

Thanks

aldo-tgh
Partner - Creator II
Partner - Creator II

Hi Aaron,

Can you please share how do you get connected to Pervasive database?

Thanks in advance,

Aldo.

Anonymous
Not applicable
Author

We ended up NOT extracting from Pervasive directly into QlikView due to all the issues.

IT ended up creating extracts into SQL and then we load from SQL into QlikView.  Not sure what that process was.

Sorry not necessarily the news anyone wanted to hear.

aldo-tgh
Partner - Creator II
Partner - Creator II

Those are not good news.

Thanks for your answer.

rbecher
MVP
MVP

Out of curiosity, does anyone has tested the Pervasive JDBC driver with our QlikView JDBC Connector? Maybe this could solve the server connectivity..

- Ralf

Astrato.io Head of R&D
gs_victa_nl
Partner - Creator
Partner - Creator

Hi Ralf,

Would it work? A QV 11.2 SR8 with a Pervasive JDBC driver and a connection throught to your QlikView JDBC connector?

I cannot find a solution for Pervasive v9 db and Qlikview version 11.2 SRx

Kind regards, Gerald

rbecher
MVP
MVP

Hi Gerald,

I would expect that this works but haven't tried..

- Ralf

Astrato.io Head of R&D
gs_victa_nl
Partner - Creator
Partner - Creator

Hi Ralf,

Any idea how to test this?

Any information would be interesting,

Kind regards, Gerald

rbecher
MVP
MVP

Download and configure JDBC Connector:

http://bit.ly/xYazjT

Pervasive JDBC driver:

http://www.dbschema.com/pervasive-jdbc-driver.html

Astrato.io Head of R&D