Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aaroncouran
Creator III
Creator III

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
Partner

Hi Aaron,

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

Thanks

aldo-tgh
Partner
Partner

Hi Aaron,

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

Thanks in advance,

Aldo.

aaroncouran
Creator III
Creator III
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
Partner

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

Vizlib Head of R&D
gs_victa_nl
Partner
Partner

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

Vizlib Head of R&D
gs_victa_nl
Partner
Partner

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

Vizlib Head of R&D