Known Bugs and Limitations

As of version 1.0b6r9, the reported bugs are:

1. On Windows, file-based data sources do not work. A workaround is to use System or User data sources.
2. In the ODBC Query Tool menu, if you delete the last query you had saved (i.e. there should be no saved queries left), the menu won't update itself until a Frontier restart. This looks like a bug inherent to Frontier's menu handling, and there is no known workaround.
3. Microsoft Access: Retrieving fields of type Date/Time will fail. It has also been noticed that even though a first ODBC call may erroneously return the empty set, subsequent calls using the same SQL statement will return data, and thus yield different results. This all probably stems from a Microsoft Access bug documented on the Microsoft website. It is reprinted here for your convenience. Basically, the gist of it is that date/time fields in MS Access are problematic. The article gives some workarounds. Thanks, Brad Marsh.
4. There is a problem when running the init() script in Windows 95. The culprit is file.getVersion(), which seems to be broken when trying to access DLLs. In Windows NT it works without a problem. What you need to do in Windows 95 as a temporary workaround is to comment out the bundle that starts with "if file.getVersion(.....". Then rerun the init script. In 1.0b6r9, the offending line is already disabled. Another better solution is to upgrade to the latest Frontier 5.02 application. The file.getVersion() bug was fixed somewhere around 5.02b14.

Warning for users of ODBC extension version 1.0b4r8!

Version 1.0b4 of the ODBC DLL has major bugs. Please update to b6 as soon as possible!

Found any other bugs? E-mail henri@binarycompass.com

Reminder: For news on the latest version of extensions.ODBC, visit http://www.tallent.com/root/system/extensions/odbc.html.
And don't forget to read the release notes in your root, at extensions.ODBC.["release notes"]

Thanks for reading through!

Henri Asseily
henri@binarycompass.com
Binary Compass Enterprises
Los Angeles, CA.

Page 1: Before the installation
Page 2: Installation of the ODBC extension to Frontier
Page 3: ODBC Functions
Page 4: ODBC Query Tool
Page 5: Old DLL Versions
Page 6: Known Bugs and Limitations