ODBC
ODBC or Open DataBase Connectivity is discussed on the following pages:
Installation
You should use the latest BRODBC32.dll
4.3 (unfiltered)
(documentation from this point on refers to ODBC 2 release with BR! 4.3.)
Improved installation routines:
- Easy to use
- Compatible with Windows Vista/7
- Compatible with 64 Bit Machines (32 Bit Drivers for 64 bit Machines).
- Easily create DNS entries from the CONTEXT using a BR program called CREATE_INI.BR. ( Taylor the resulting INI file to the target setting. )
- Installation on a client can be done from a command line avoiding the need for human interaction at the client.
Support for 64 bit Record Locking (No 2GB Limit!)
Implemented Dynamic (on the fly) Indexes
Logging:
Set Logging to level 6.
LOGGING 6, C:\ODBC-LOG.TXT
Log file will provide helpful information to analyze queries. Actual SQL processed by Driver (As opposed to the SQL typed in MS-Access or MS-Excel) Indexes used by the Query. (To help determine the "BEST Query" for performance).
More Robust:
Improved Date Handling (Sort/Filter, etc). Improved Joins leverage &/or create indexes for performance. Improved Group By queries Improved "Like" filters. Improved Multiple Filters in a single query
License enforcement has been improved with this release.
- Note: Older versions of ODBC did a poor job of enforcing Licensing, and would sometimes allowed too many users to use the product. (Accidentally violating the license).
New Procedure for Utilizing MS Access ODBC Middleware
A procedure has been established for greatly expanding the SQL capabilities of the BR ODBC driver by routing ODBC requests through MS Access. Using this technique one can create reusable queries that combine several tables.