Smithware Home PageSmithware Product InformationHow to Order Smithware ProductsSmithware Technical SupportSearch the Smithware Web SiteBtrieve Developer's Journal MagazineContact Smithware by E-mailPervasive Software Home Page Smithware Home Page

Btrieve

Note: On February 13, 1998, Smithware was acquired by Pervasive Software. This site is an archive of the materials that were on the Smithware site when www.smithware.com was routed to www.pervasive.com. This site is maintained for archival purposes only.

ActiveX Controls for Btrieve
I*net Data Server
Crystal Reports for Btrieve
DDF Builder
DDF Sniffer
VBX Controls for Btrieve
Butility for DOS


Other Products Available Through Smithware's Product Marketing Group:

BSqueeze
Btrieve
ODBC Interface
Scalable SQL

Note: On February 13, 1998, Smithware was acquired by Pervasive Software. This site is an archive of the materials that were on the Smithware site when www.smithware.com was routed to www.pervasive.com. This site is maintained for archival purposes only.



"The primary feature is speed -- it means the day-end cycle is a couple of minutes, not overnight. The primary benefit is that we move to 24 hour operations without shutting our store down for hours to run batch processing."

Terry Barrett
Software 4 Data Systems, Inc.

As the industry standard navigational client/server database, Btrieve 6 is used by professional developers, independent software vendors (ISVs), and value-added resellers (VARs) to build mission critical applications. Btrieve 6 offers maximum programming control and performance.

Built on Pervasive's MicroKernel Database Engine, Scalable SQL and Btrieve 6 applications can access all data concurrently.

Btrieve 6 won the 1995 RealWare Award for "Client/Server Computing in Support of Mission Critical Operations." Be sure to check out what our customers have to say about our products.

Take the Safe, Direct Route to Client/Server.

It's commonly believed that a change to client/server has to be both costly and difficult while yielding uncertain results. Not anymore. Upgrade to the Btrieve 6.15 Server!

Now Btrieve 6 Charts A Better Course.

With today's state-of-the-art version of the world's most trusted database, you can move to client/server without giving up the control you, as a professional programmer, demand. And the results are far more certain.

Launch With Navigational Client/Server.

As the first navigational client/server database, Btrieve 6 provides maximum programming control by allowing you to navigate up, down, and sideways through the database at a record level. As a result, you can fully apply your knowledge of application design and database structures to deliver unparalleled performance. And you can add SQL applications at any time.

With Btrieve 6, you can design relational structures and follow them with precise directional controls to update retrieve, insert and delete distributed data. So you'll have the control to chart the fastest path to your data.

Using your existing 3, 4 and 5GL tools, you can create or replace your data management code with Btrieve 6. Then, couple it with your application code and you're there.

Btrieve 6 directional controls integrate with your current application code, allowing you to selectively upgrade your familiar applications to client/server. Since this data management change is transparent, your end users won't need the kind of massive retraining that accompanies a sweeping change to new applications retraining that can take a surprising 40-50 percent of the typical conversion budget (Source: The Gartner Group).

Scale From Standalone to Client/Server With No Recoding.

Once you create an application with Btrieve 6, you can deploy in any configuration without recoding. You can develop on a laptop at home using Btrieve for Windows. Once back at work, simply move the application and data to the network for immediate multi-user access. For maximum performance, snap in the Requester Module, connect to a Btrieve database server running on NetWare, Windows NT or OS/2, and accelerate to client/server data processing supporting hundreds of users.

Seaworthy Reliability, State-Of-The-Art Performance.

Btrieve has, for many years, been the benchmark for reliability and performance in database management. In the highly competitive accounting software market where reliability and performance are paramount, seven of the top ten vendors choose Btrieve.

Now, there is Btrieve 6. Based on the new MicroKernel Database Engine, it delivers the transaction processing muscle to build multi-gigabyte database servers supporting hundreds of users with sub-second response rates. It guarantees data integrity through rich transaction processing support, referential integrity controls and automatic file recovery. In the event of a server or system failure, logging and roll forward utilities allow you to recover to your last transaction.

Other state-of-the-art features include internal indexing algorithms that use extensive page caching for lightning fast data retrieval and update, plus automatic index balancing to insure that data access speed doesn't degrade as your files grow. Btrieve 6 servers also offer continuous operations, keeping your data on-line around the clock, seven days a week, without interruption for back-ups or batch processing.

Given all that, perhaps the biggest benefit of the MicroKernel architecture is how it enables you to move easily between navigational and relational applications.

The Painless Course to SQL.

Both Btrieve 6 and Scalable SQL, our award-winning relational database, are built on the MicroKernel Database Engine, which stores all data in a common, model-independent format. As a result, Btrieve applications work in unison with SQL applications each having concurrent access to all data. Now you can take full advantage of new applications and data types without impacting your original applications.

For example, you can develop relational query and reporting modules to extend your navigational accounting system, leveraging the strengths of each database model in parallel, avoiding the expense of a database migration. You'll be able to move easily from one environment to another, one application at a time, eliminating sudden, all-or-nothing migrations and allowing you to train and convert your people at your own pace. In addition, your existing applications will continue to serve your remaining users while providing a proven, reliable alternative for everyone.

Anchor Your Operations In Btrieve 6 And Relax.

Btrieve 6 delivers low-maintenance, resource efficient operations without on-going tuning by database administrators. It increases data files dynamically so you never have to worry about pre-allocating disk space or reorganizing.

Likewise, when you delete data, newly freed space is automatically reused. And it makes optimum use of disk space through automatic data compression, blank truncation and variable-length record management.

Even the variable cache buffer automatically adjusts page-caching for faster data retrieval without manual retuning. And with the MicroKernel Engine's efficient use of memory, you won't have to upgrade your hardware every time you add users.

In short, all you have to do is set it and forget it.

Set Sail With The Ease of Navigation.

Btrieve 6 offers smooth sailing. You'll have the control and convenience of using your own tools and writing in your own language. The trip to client/server will be much more manageable and you'll have the freedom to write new applications in Btrieve or SQL. So navigate the safe, direct route to client/server with Btrieve 6.

Upgrade to the Btrieve 6.15 Server!

Features
As the industry standard navigational client/server database, Btrieve 6 is used by professional developers, independent software vendors (ISVs), and value-added resellers (VARs) to build mission critical applications. Btrieve 6 offers high performance with a maximum degree of programming control and performance.
  • Maximum Programming Control. Record-level data access provides maximum programming control for optimizing application and database performance.
  • High Performance Data Access. Automatic index balancing and advanced data caching are self-tuning for optimal data access performance.
  • MicroKernel Database Architecture. The MicroKernel Database Engine handles core database functions. This allows integration of Btrieve and Scalable SQL applications that concurrently access the same data.
  • Full Scalability. Applications can scale from mobile systems to peer-to-peer and to client/server operations without modifications.
  • Maintenance-free Operation. Eliminates the need for on-going database administration.
  • Rich Transaction Processing. Concurrent and exclusive transactions allow programmers to ensure database consistency and minimize data record locking.
  • Dynamic File Expansion. The size of data files is dynamically increased as required, eliminating the need to pre-allocate disk space.
  • Sophisticated Data Recovery. Database logging and roll forward capability provide the ability to recover from system errors such as disk failures.
Btrieve v6.15 Client/Server Database Upgrade Summary

Btrieve v6.15 (Server Edition) for NetWare(r) and Windows NT(c) offers significant new features and enhancements.
  • Improved Performance. Achieved through enhanced data caching and bundled file updates. Btrieve server engine performance is up to 65 percent faster for insert operations and 26 percent faster for read operations compared to Btrieve 6.10. Applications using server based NLMs and those using extended read and insert operations will see the largest performance increase.
  • Improved Database File Integrity. Protects data from server system failures that may be caused by hardware failures or power outages. Btrieve now automatically provides the same level of file integrity as the NetWare Transaction Tracking System (TTS), without the performance reduction currently experienced when using Btrieve with TTS mode files*. File integrity during Continuous Operations is also improved.
  • Windows(c) DLL Requester. Loads dynamically when needed eliminating the need for static allocation of real mode memory on Windows workstations.
  • Windows NT / Windows 95 Requester. Provides support for 32-bit client/server applications.
  • Dual Mode Requesters. Provides applications concurrent access to both NetWare and Windows NT Servers. A NetWare only DOS requester is also provided to minimize real mode memory requirements.
  • Support for NetWare SFT III. Enables you to configure fault tolerant mirrored database servers to insure maximum uptime for critical Btrieve applications.
  • Windows based Installation Utility. Provides a graphical user interface (GUI) to simplify installation of Btrieve on the database server.
  • ODBC Interface Requester License. Available to allow ODBC applications full access to Btrieve databases on your server.
*In addition to the performance of the Btrieve server engine, overall system performance is dependent on a wide variety of factors including the hardware configuration, network overhead, application design, and the number of users. The use of server-based NLMs and extended read and insert operations reduces network overhead. Since TTS-level file integrity is now provided automatically by Btrieve 6.15, users that have selected TTS mode will no longer experience reduced performance compared to non-TTS mode operation. Additionally, the realized performance increase is greater for higher user count systems. For example, in a simple insert test comparing Btrieve 6.15 to Btrieve 6.10 with the TTS option selected, performance was increase by 21 percent in a five user configuration and by 45 percent in a 50-user configuration.

Btrieve for Windows NT/Windows 95 v6.15

Using Btrieve v6.15 for Windows NT/Windows 95 developers can start building full 32-bit applications today, taking advantage of the 32-bit support provided by Windows 95 and Windows NT.
  • Full 32-bit Application Interface and Database Engine. Allows applications to use the 32-bit capabilities provided by the operating system and processor. This provides significant performance improvements over 16-bit applications.
  • Common Engine for Windows 95 and Windows NT. The application and database engine can be deployed on either Windows 95 or Windows NT; therefore developers can target both environments with a single product.
  • Supports 16-bit Btrieve Applications. 16-bit Btrieve Windows applications can coexist with new 32-bit applications and share files through a common Btrieve database engine.
  • Multi-Tasking Support. Supports preemptive multi-tasking, which allows for more efficient use of computing time and operation when executing multiple programs concurrently.
  • Registry Support. Takes full advantage of the Windows 95 and Windows NT registry feature for centralized application configuration.
  • Maximum Programming Control. Record-level data access provides maximum programming control for optimizing application and database performance.
  • High Performance Data Access. Automatic index balancing and advanced data caching are self-tuning for optimal data access performance.
  • MicroKernel Database Architecture. The MicroKernel Database Engine handles core database functions. This allows integration of Btrieve and Scalable SQL applications that concurrently access the same data.
  • Full Scalability. Applications can scale from standalone to peer-to-peer and client/server operations without modifications.
  • Maintenance-free Operation. Eliminates the need for on-going database administration.
  • Rich Transaction Processing. Concurrent and exclusive transactions allow programmers to ensure database consistency and minimize data record locking.
  • Dynamic File Expansion. The size of data files is dynamically increased as required, eliminating the need to pre-allocate disk space.
  • Sophisticated Data Recovery. Database logging and roll forward capability provide the ability to recover from system errors such as disk failures.

Products Platform & Contents
Client/Server Database Engines

Available for: NetWare and Windows NT. Each Btrieve 6 Client/Server Database Engine product contains:

  • Installation and file management utilities for database configuration, file conversion, maintenance, and roll forward.
  • Manuals and reference guides for installation and operation, status codes and system messages. Client requester modules providing client/server access to a server-based Btrieve engine.
  • Server-based MicroKernel Database Engine, SPX server-to-client communication module, SPX server-to-server data routing, and server-based configuration and monitoring utilities.
  • Client/Server Database Engines are available according to user count: 10, 20, 50, 100 and unlimited.


Workstation Database Engines

  • file-sharing
  • stand-alone
  • peer-to-peer


Available for: DOS, OS/2, Windows, Windows NT AND Windows 95. (Windows and Windows 95 include ODBC interface)

Each Btrieve 6 Workstation Database Engine product contains:

  • The engine for the appropriate platform (multi- or single-user mode). An unlimited distribution license.
  • Installation and file management utilities for database configuration, file conversion, maintenance, and roll forward.
  • Manuals and reference guides for installation and operation, status codes and system messages.
  • Client requester modules providing client/server access to a server-based Btrieve engine, plus local access to a Btrieve engine.


Developer Kits

Available for: DOS, OS/2, Windows, Windows NT, and Windows 95. Each developer kit contains:

  • Btrieve Engine licensed for use during development and testing (limited to 5 users).
  • Installation and file management utilities for database configuration, file conversion (Btrieve v5.x to v6.x), maintenance, and roll forward.
  • API programming manuals.
  • DOS: programming language interfaces for ANSI standard C/C++, Borland Pascal, and BASIC compilers.
  • OS/2: programming language interfaces for ANSI standard C/C++, BASIC/2, and MicroFocus COBOL/2.
  • Windows: programming language interfaces for ANSI standard C/C++ compilers, Borland Pascal, and Visual Basic.
  • Windows NT: programming language interfaces for ANSI standard C /C++ compilers.

System Recommendations
All Btrieve 6 Engines are 32-bit engines; therefore, they require an IBM compatible 386/486 computer.

Client/Server Database Engines

Network clients accessing the database server via the Btrieve Requester must have DOS v3.x or above, OS/2 v2.0 or above, Windows v3.1, or Window NT v3.5. On DOS clients, the DOS Requester (34KB) must be loaded. The OS/2, Windows and Windows NT Requesters load dynamically.

Additional requirements of each engine include:

  • Btrieve Engine for NetWare (Server Edition) NetWare v3.11 or above, 4MB RAM above minimum needed for NetWare, approximately 8MB available disk space.
  • Btrieve Engine for Windows NT (Server Edition) Windows NT 3.5 or above, 4MB RAM above minimum needed for Windows NT, approximately 3MB available disk space.
  • Btrieve Engine for Windows (Workstation Edition) 4MB RAM minimum, PC-DOS or MS-DOS v5.0 or above, Novell DOS 7.0, and Windows v3.1 or above.
  • Btrieve Engine for OS/2 (Workstation Edition) 8 MB RAM minimum, and OS/2 v2.0 or above.
  • Btrieve Engine for DOS (Workstation Edition) A minimum of 2MB of extended memory, 45KB to 100KB real mode memory (in addition to the memory required by the application depending on memory managers and configuration), PC-DOS or MS-DOS v5.0 or above, and Novell DOS v7.0.


Note: The Btrieve Engine for DOS is a 32-bit DOS Protected Mode Interface (DPMI) terminate-and-stay resident (TSR) program using the Tenberry Software, Inc. DOS/4G extender.

Technical Specifications
Maximum file size: 4 gigabytes

Maximum DBMS size: No limit

Maximum record size: No limit

Maximum records per file: No limit

Maximum key length: 255 bytes

Maximum keys per file: 119

Maximum open files: Only limited by operating system resources

Data types for key values: integer, float, date, time, decimal, money, logical, numeric, bfloat, string, lstring, zstring, unsigned binary, autoincrement, sign trailing separate, and numeric signed ascii

Key attributes: linked/repeating duplicatable (a.k.a. supplemental), duplicatable/non-duplicatable (a.k.a. unique), modifiable/non-modifiable, segmented/non-segmented, descending/ascending sorting, case-sensitive/case-insensitive sorting, alternate collating sequence, null (any-segment/all-segment)/non-null

Technical Specifications
Btrieve Developer Kit

Btrieve Developer Kit provides the application developer with everything required to build and test an application. Includes API documentation and software. Available platforms: DOS, OS/2, Windows, Windows NT and Windows 95.

Btrieve Workstation Engine -- Single Seat

Btrieve Workstation Engine single seat license allows users to run Btrieve-based applications on a single system, either in single-user mode or network file-sharing mode. For example, a Btrieve-based application can be configured to use local data files or to share network data files with other users without changing or relinking the application. Includes installation and operation documentation and software. Available platforms: DOS, OS/2, Windows, Windows NT and Windows 95. Windows and Windows 95 versions include Pervasive's ODBC Interface.

Btrieve Workstation Engine -- Unlimited Distribution

Btrieve Workstation Engine unlimited distribution license allows the application developer to distribute a workstation engine with an application to an unlimited number of sites. Includes installation and operation documentation and software. Available platforms: DOS, OS/2, Windows, Windows NT, and Windows 95.

Btrieve Client/Server Database Engine

Btrieve Client/Server Database Engine is licensed on a per server basis with a specific user count. Available counts include: 10, 20, 50, 100, and unlimited. Includes installation and operation documentation and software. Available platforms: NetWare and Windows NT.




 
To Order Call Toll-Free (800) 828-7438 or (615) 386-3100 or

CLICK HERE

for on-line ordering information!

 

Copyright © 1988, 1998 by Smithware, Inc. All rights reserved.
Smithware, Controls for Btrieve, DDF Builder, DDF Sniffer, Btrieve Developer's Journal, and Power Tools for Btrieve are trademarks of Smithware, Inc. Btrieve is a registered trademark of Pervasive Software, Inc. ActiveX, Windows, Windows NT, and Internet Explorer are trademarks of Microsoft Corp. All other product or brand names are trademarks or registered trademarks of their respective owners. Legal Notice.