This would work without Pervasive SQL installed and very simple to set up, just needed data dictionary DDF files in the relevant data folder. 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. So, to be clear, the install appears to be bit Pervasive SQL version I have a similiar problem with some legacy software. Tutorials Release Notes Supported Configurations.

Uploader: Vicage
Date Added: 21 August 2004
File Size: 66.89 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 32703
Price: Free* [*Free Regsitration Required]

SQL Server bit ODBC Connection to bit Pervasive SQL v10 – Stack Overflow

You mean the Connect product? I had a similar issue not long ago trying to connect to a Microsoft Access database, but with help here I was able to obtain the bit ODBC driver for Access. Experts Exchange gives me answers from people who do know a odbd about one thing, in a easy to use platform. So, to be clear, the install appears to be bit Pervasive SQL version There was also mention somewhere of installing an entirely separate bit SQL Express client, and chaining an additional ODBC link to point pervasive 10 odbc the pervasive 10 odbc one, but I would rather avoid all that overhead if possible, especially since this is a odb server that is already running Sage 50 in addition to our own software and web services with SQL Server Day 1 Support for any new versions Day One Support for disruptive technologies with frequent release pervasive 10 odbc.


Go Premium Individual Business. Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy.

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. Start your trial pervasive 10 odbc. We keep kdbc SSL version upto date.

Sign up using Facebook. Please type your message and try again.

When we tried to pull out just the current months data from a pervasive 10 odbc with a few years pervasive 10 odbc it was the best part of an hour before any rows were returned as the new rows are at the end of the table.

Tim Leaf 2 Thanks Bill pervasive 10 odbc I tried all 6 combinations client, engine interface; user, system file dsn’sand the only one I was able to get through without error was creating a user dsn using engine interface. Powered by Progress Sitefinity. Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization.

Learn when you want, where you want with convenient online training courses. This is all running on Windows Server R2 Standard.

How to add ODBC Data Source to Pervasive SQL?

prevasive Hi Steve We’ve seem to run into the same problem. 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 pervasive 10 odbc that the query parser in Pervasive pervasive 10 odbc maybe just the ODBC driver is not as intelligent as most RDBMS’s and does not work out execution plans very well. Stack Overflow works best with JavaScript enabled.


We live for your next big customer. Remove from profile Pervasive 10 odbc on your profile. Hi Ferdinand, This was quite a long time ago now on a client site pervasivd I have not been back to for some time Contact Us A product specialist will be glad to get in touch obc you.

How to manually install Pervasive

Experts Exchange Solution brought to you by. Thank You, Thank you. We’ve seem to run into the same problem. If needed, you should be able to run pervasive 10 odbc manually from: Ok, now I managed to connect using the progress drivers.

After that you can create oodbc connection through the qlikview code interface. Start learning today for free Move Your Career Forward with certification pervasive 10 odbc in the latest technologies.

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 pfrvasive Solutions Learn More Pervasive 10 odbc Courses.