Technical White Papers
This page contains white papers created by Goldstar Software Inc. Click on the PDF icon to download the complete document in Acrobat format. Click on the paper name to see the HTML version (if available).
Can't open PDF files? Please visit www.adobe.com for a free download of Adobe Acrobat Reader.
White Papers Regarding Data Access...
 Accessing Btrieve Data From ODBC or Other Applications
MANY people want to access Btrieve data via other applications or ODBC drivers as easily as they access
SQL Server, Oracle, and MS Access databases. This paper explains why this task isn't so easy, &
provides a basis for getting started.
Determining My Btrieve Engine Version
This article covers the various aspects of determining your database engine version.
White Papers Regarding Status Codes...
Status 46 Messages
Having problems with Status 46 messages coming back from your applciation, causing users to lose database changes? This paper can help!
Status 8013 After Installing Pervasive.SQL V8.5
If you just installed Pervasive.SQL V8.5 onto a system and you are now getting a Status
8013 when starting the application, here's how to fix it!
Status 94 Frequently Asked Questions
Many sites fight the dreaded Status 94 -- Permission Denied -- and cannot figure out how to get around it.
This document reviews the primary causes of Status 94 errors with Btrieve and Pervasive.SQL.
Status 95/3111 Frequently Asked Questions
Are you plagued by chronic Status 95 (or Status 3111) problems? This FAQ list details the primary causes and
provides some relief!
Status 2009 After Installing Pervasive.SQL V8
If you just installed Pervasive.SQL V8 onto a system running Pervasive.SQL V7 and you are getting a Status
2009 when starting the application, here's how to fix it!
White Papers Regarding Installation and Configuration...
Entering your Pervasive License Key
Status 161 error? Having problems with your Pervasive License key? Try this paper!
Checking your Pervasive Installation for Proper Operation
If you are wondering if you have successfully installed the Pervasive engine, here's how you can check it.
Setting a Permanent Gateway
The Pervasive.SQL 2000i and Pervasive.SQL V8 WorkGroup Engines work best when you can lock down the gateway
to a single computer. Here's how & why...
Setting up the WorkGroup Engine as a Service
If you use the Pervasive.SQL WorkGroup Engine on a server and do not log into the server every day, then you will need to configure the database engine to start as a service.
This paper explains how to configure this so that the WGE works without logging in.
Forcing the Requester Version Information
This article explains how to force the Pervasive.SQL 2000i (or newer)
requester to return an older Version Number, so that older applications can work with the newer database engines.
Disable the DOSBOX Redirector
This article explains how to disable the DOSBOX redirector to get an old Btrieve for DOS application peacefully
coexisting with a newer Pervasive.SQL application.
Pervasive.SQL 2000 Backward Compatibility
Pervasive Software bills the Pervasive.SQL 2000 database engine as "backward compatible" with older
applications. This paper examines the core issues in this claim!
Creating a Pervasive ODBC Data Source
If you already have DDF's, and just need to create a data source to access your database from ODBC, follow these quick instructions!
White Papers Regarding Maintenance and Troubleshooting...
Btrieve Data File Maintenance
What does it take to rebuild corrupted Btrieve data files? This excerpt from our first Service & Support
class covers most of the basics for you!
Using Continuous Operations For Proper Backup
This is a link to the article below regarding proper backup.
Rebuilding Database Files to the Newest File Format
Rebuilding files to the latest Pervasive file format can often provide substantial performance gains. Here's
how to do it!
Testing your Network with the Pervasive System Analyzer
This article explains how to test your network's communications speed and reliability
with the Pervasive System Analyzer. Users with older engines can do the same tests with SmartScout.
Obtaining a UserDump on a Windows Server
This paper discusses how to get a memory dump of the Pervasive database process on Windows Servers.
Obtaining an MKDE Trace to Troubleshoot a Failing Application
This paper discusses how to get a Microkernel Database Engine trace to show the exact point at which an application fails.
Having a valid trace leads to quicker resolution of problems you may encounter.
| 
