What is the BASIS ODBC Driver?

The BASIS ODBC Driver is a tool that opens existing BASIS data files to productive Windows applications such as Crystal Reports, Microsoft Access, and Microsoft Excel. By providing a thin layer of connectivity between BBx data and a wide variety of Windows applications, the BASIS ODBC Driver eliminates the need to create custom import/export tools to access existing data files.

The BASIS ODBC Driver comes bundled with DDBuilder, BASIS's stand-alone graphical data dictionary utility. DDBuilder allows the creation of new dictionaries and relational views as well as allowing the editing of existing dictionaries.

The BASIS ODBC Driver comes ready to connect to the PRO/5 Data Server. Using the BASIS ODBC Driver to connect to the PRO/5 Data Server increases performance when accessing data on UNIX or Windows NT platforms.

The BASIS ODBC Driver supports:

• Read-only or read/write data access

• Over 60 scalar functions

• API functions: Core (24), Level 1 (15), Level 2 (7)

• Fourteen familiar commands that can be used in SQL expressions

• Traditional BBx string concatenations

• Character set translationOBDCDriv_Character_Translation

• Relational views

• PRO/5 Data Server communication via TCP/IP

• Three levels of automatic log file entries (New in Rev.2.0 and above.)

• Outer joins, including multi-tier outer joins (New in Rev.2.0 and above.)

• Subqueries using nested SELECT statements (New in Rev.2.0 and above.)

• Column abbreviations in queries