Pervasive Sql 10 Odbc Driver Download Install Update
Perhaps there is also free? I am going to start with ODBC. Thank You, Thank you. You need to download the trial version from here: Then only install the pervasive client, not the server trial version. If you're on a bit server then you still need to install the bit client. Hi There, There is a bit of a gotcha with using Pervasive databases, unless someone is aware of a way around this It would appear that when the ODBC connection is used that any indexes set up in the Pervasive database are not employed - so a full table scan is used each time.
When we tried to pull out just the current months data from a table with a few years history it was the best part of an hour before any rows were returned as the new rows are at the end of the table.
Doing this in the desktop version of QlikView it appears to hang, as the time elapsed is only updated as rows come in, it is also impossible to cancel out cleanly unless rows are being brought in. We've seem to run into the same problem.
Have you managed to derive a work around since your last post? This was quite a long time ago now on a client site that I have not been back to for some time We did get the data extracts going at a sensible rate in the end, and I seem to recall that the indexes would be used provided the SQL statement was structured to exactly match the index. For example, make sure the fields in the where clause appear in the same order as they do in the index.
The requirement for this derives from the fact that the query parser in Pervasive or maybe just the ODBC driver is not as intelligent as most RDBMS's and does not work out execution plans very well. If you have serious amounts of data you need to move about and want bespoke drivers then I can recommend speaking to a company called Attunity. Getting data from 'classic' systems is what they are all about. This may be stating the obvious - but if you have slow data transfer from your source system put some thought into QVD usage and incremental loads - search Qlik Communities for more information on this.
You mean the Connect product? I liked the value proposition they propose, but I am interested in the Pervasive data. Just quickly I've had some experience connecting to Pervasive databases when supporting a Sage product Platinum for Windows if that rings a bell This would work without Pervasive SQL installed and very simple to set up, just needed data dictionary DDF files in the relevant data folder. Re performance it seemed to work quite well on large data sets but hard to say if there will be an improvement over Pervasive ODBC drivers.
It looks like newer versions are available from DataDirect if you wanted to contact them for more info: Ok, now I managed to connect using the progress drivers.
Still, I am only able to pull data from one table at a time. When you say one table at a time, I'm assuming you can't run any join operations, etc. I will have to perform additional operations with other dbs as I feel the problem is the export itself. Will let you guys know. Please enter a title. You can not post a blank message. Please type your message and try again. Feb 24, 9: This content has been marked as final.
After that you can create a connection through the qlikview code interface. Hi Steve We've seem to run into the same problem. Hi Ferdinand, This was quite a long time ago now on a client site that I have not been back to for some time I'll test over the weekend. How did it go? Hi Guys, Just quickly I've had some experience connecting to Pervasive databases when supporting a Sage product Platinum for Windows if that rings a bell Hi Felix, that's good news.
Where did you source the progress drivers from? Go to original post. Remove from profile Feature on your profile.
Actian PSQL™ v10
Selecting a language below will dynamically change the complete page content to that language. You have not selected any file s to download. A download manager is recommended for downloading multiple files. Would you like to install the Microsoft Download Manager? Generally, a download manager enables downloading of large files or multiples files in one session. Many web browsers, such as Internet Explorer 9, include a download manager. Stand-alone download managers also are available, including the Microsoft Download Manager. The Microsoft Download Manager solves these potential problems. It gives you the ability to download multiple files at one time and download large files quickly and reliably. It also allows you to suspend active downloads and resume downloads that have failed. Microsoft Download Manager is free and available for download now.