Application Support for DBA Software
For application-specific support, please visit the IS Tech Support or Evo-ERP web sites.
Older versions of DBA Classic may have Btrieve 6.15, Pervasive.SQL 2000i, or Pervasive.SQL V8 components installed, but the vendor has indicated that this entire product line will work on any current version of Pervasive, including Pervasive PSQL v9.5. (For any new installations or upgrades, you will probably move to PSQLv9.5, if you have not already.)
Like Goldstar Software, IS Tech is also a Pervasive reseller, so if you plan on requesting support from them on the application, you may be best off purchasing the Pervasive upgrade from them. IS Tech Support recommends that users use the current PSQL v9.5
WARNING: DBA Software provided the PSQLV8 client with their last (2004) update without regard for the server PSQL version. This situation potentially created a problem with the PSQLV8 client logging into a PSQL2000 server. This engine/client mismatch can cause major problems, from server-side crashing (if the SP4 HotFixes are not yet applied) to other strange results. DBA may load, but sporadic unpredictable errors will result. The possible solutions to this are:
- Remove the PSQLV8 client from each workstation and install the PSQL2000i client instead. This ensures that you have the same versions, although the PSQL2000i software has not been sold nor supported since 2004.
- Upgrade your older PSQL engine on the server to PSQLV8 (at minimum). This is a paid upgrade (not free). If you upgrade to V8.7 (Service Pack 3), you may also need to patch the clients anyway.
- Upgrade your entire environment to the currently supported Pervasive PSQL v9.5 software. Since you may have to touch all machines anyway, why not upgrade to the latest & greatest engine from Pervasive?
Update 12/11/2007: After receiving a few calls about people wanting to upgrade, we did some more research on this, and found several users already running DBA Classic on Pervasive PSQL Summit v10 with no issues. This is great news, and should allow anyone running an older engine to get on the newest one, including Vista support. (Users are also successfully running DBA Classic on Vista, as well.)
Update 01/28/2011: Lynn Pantic at IS Tech Support has indicated that users are working fine on Pervasive PSQL v11, as well.
Update 01/2015: Lynn Pantic at IS Tech Support has indicated that users are working fine on Pervasive PSQL v12, too. If you are looking at a new database engine purchase, you will likely want to get the newest release.
The following application-related information may be helpful to you over time:
- Install Tip: If you are installing PSQLv10 or PSQLv11, you must install the 32-bit PSQL Client to use Evo or DBA, even on 64-bit computers. With PSQLv12, the installer is smart enough to install exactly what you need.
- Mapped Drives: Evo can be either looking at a mapped drive or UNC path. If you are starting clean, I recommend using the full path to the share and forget the mapped drive. This information is stored in the C:\ISTS\TASPRO7.INI on each workstation in 3 lines in the [Setup] section at the beginning of the file.
- Moving to a New Server: Migrating to a new server is easy. There is really nothing to it other than installing the correct Pervasive engine and copying in the backup of the DBAMFG folder and sharing it. That is all you need to do to get DBA/Evo up and running. For the JDBC programs in Evo and any ODBC connections you may have, you need to load the Pervasive Control Center and create a database pointing to the company subfolder. It is best to use the same database name that was used on the old server. In Evo you will need to go to SM-T and change the Host to the new server name or IP address unless you are replicating the old one in which case no changes are needed.
- Setting up JDBC: ISTechSupport has a paper on how to set up JDBC, which you can see here.
- Creating DDF Files: Evo has an option for Generate DDF Files within the menu system, specifically UT-J. That option should ONLY be used for database maintenance within the old DBA Classic. The option UT-A, "ODBCDDF" creates the correct DDFs in the company subdirectory without file extensions.
- Connecting via ODBC: When creating a database link via the PCC for ODBC access, you should NEVER use the DDF's located in the DBAMFG root directory. (These DDF's are invalid and will not work within PSQL.) Instead, you MUST use the aforementioned ODBCDDF tool to create the company-specific DDF's in your company folder, and then create a Named Database that points to the specific company folder itself, such as DBAMFG\Default.
If you are a software vendor and would like to add, remove, or modify your information on these pages, we'll be happy to oblige. Simply contact us directly!