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

ODBC Interface

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 was routed to 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:

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 was routed to This site is maintained for archival purposes only.

The industry-standard solution for connecting ODBC-compliant applications and tools to access Scalable SQL and Btrieve databases.

This powerful, industry-standard interface offers superior flexibility, automatic tuning, and the highest performance available. With the ODBC Interface, giving applications access to Btrieve and Scalable SQL data is easier than ever before.

Superior Data Access

ODBC Interface is tightly integrated with Pervasive's MicroKernel Database EngineTM (MKDE) architecture -- enabling developers to achieve fast, efficient access to all Scalable SQL and Btrieve data.

High-Performance ODBC Engine

This ODBC engine makes full use of Pervasive's SQL parsing and indexing technology and database engine performance features.

Full Scalability

ODBC Interface lets developers scale an application from mobile Windows systems, to peer-to-peer networks, to client/server environments -- without modifying the application itself.

Multiplatform Support

ODBC Interface provides robust support for today's most widely used platforms: Windows, Windows NT and Windows 95 accessing NetWare, Windows NT Server, and OS/2 Warp Server.

Distributed Access

With ODBC Interface, the Scalable SQL or Btrieve database can reside across multiple NetWare or Windows NT servers. What's more, the location of data is completely transparent to the application requesting it.

Maintenance-free Operation

Simple to install and use, ODBC Interface requires no extensive performance set-ups. Nor does it need ongoing tuning by a DBA.

Feature Highlights
Support for Windows NT, Windows 95 and Windows 3.x

ODBC Interface offers 16-bit support for Windows 3.x and full 32-bit support for Windows NT and Windows 95.

Support for Popular Development Tools

With ODBC Interface, developers can instantly integrate with a wide range of prominent 16- and 32-bit ODBC enabled database applications -- applications that include Microsoft Access, Delphi, Visual Basic, Powerbuilder, Crystal Reports, and many more.

European Language Support

Included in ODBC Interface are new translation DLLs that enable quick, easy OEM-to-ANSI conversion. With its support for European languages, ODBC Interface dramatically simplifies the task of reworking applications for deployment in different global markets.

ODBC Level 2 Conformance

ODBC Interface conforms to ODBC Level 2 API specifications. New APIs supported include SQLSetPos and Bookmarks, SQLExtendedFetch and Positioned SQL Statements. Within a GUI application, you can position on any row and traverse the rows as needed. Insert, update and delete table rows faster than ever before. You can also retrieve values from multiple rows which results in decreased network traffic and dramatically improved performance.

Extended SQL Grammar Conformance

ODBC Interface fully conforms with core SQL grammar and also supports extended SQL grammar elements. UNIONs, batched SQL statements, and data types such as long character, binary, date, time, and timestamps are supported, as are scalar functions such as string and numeric functions, outer joins, and procedure invocation. ODBC Interface is fully functional with Scalable SQL and Btrieve datatypes.

Product Licensing
Pervasive Software offers a range of licensing options for distributing ODBC applications commercially, on a workstation-by-workstation basis, and within a client/server environment.

ODBC Interface Requester License

Included with the Scalable SQL and Btrieve server products, the ODBC Requester License is provided on a per-server basis. It allows for the use of ODBC Interface on all workstations that are connected to a licensed Scalable SQL or Btrieve server.

Single Seat License

The ODBC single seat license is included with Pervasive's Scalable SQL and Btrieve single seat workstation engines. Appropriate in an environment where a relatively limited number of users are running workstation-based ODBC applications, this licensing option allows users to purchase the precise number of licenses they need on a seat-by-seat basis.

Commercial Deployment Kit

Designed for the commercial developer who needs to distribute ODBC Interface with widely deployed, workstation-based applications, the Commercial Deployment Kit allows for the distribution of up to 1,000 seats of the ODBC Interface. Deploying a 20-user copy of an application, for example, counts as 20 seats.

The ODBC CDK includes both 16-bit and 32-bit ODBC Interface, and can be used in conjunction with Scalable SQL CDK or Btrieve unlimited distribution license.

Technical Specifications
Operating Systems Supported: Microsoft Windows v3.1, Windows NT Workstation v3.51 or later, Windows 95

ODBC Level 2 Conformance: All ODBC Level 2 API functions except for SQLBrowseConnect, SQLProcedures, and SQLProcedureColumns

Dynamic Cursor Model: Return multiple records, Bi-directional scrolling, Rapid random-access positioning

Thread-Safety: Safe for use in multiple-threaded programs or within application servers such as Web servers

Concurrency Support: Explicit and implicit record locking, as well as exclusive database access

Named Database Support: Available when used with Scalable SQL

Client/Server Support

Transaction Support

Multi-tier Configuration

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


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.