These drivers are fully functioning versions intended for evaluation purposes. You will be able to install the drivers and connect to your database. The only limitation is that they will only return the first 3 rows from any query. Once you have purchased a license key, all rows will be returned from your queries.
NOTE: There is no charge for the upgrade to version 2.x of the drivers for existing 1.x customers.
Actual ODBC Pack v 2.9d (for Mac OS X)
The Actual ODBC Pack installs the latest version of several Actual Technologies ODBC drivers. The included drivers and their version numbers are listed below:
- Actual SQL Server 2.9b (Microsoft SQL Server and Sybase)
- Actual Open Source Databases 2.9b (MySQL, PostgreSQL and SQLite)
- Actual Oracle 2.9e
- Actual Access 1.9 (.mdb, .accdb, .xls, .csv and .txt files)
Actual ODBC for OpenBase v 2.2
This driver connects to databases from OpenBase International. It does not connect to MySQL or PostgreSQL. To connect to MySQL or PostgreSQL, please use our Actual ODBC Driver for Open Source Databases, included in our Actual ODBC Pack (above).
NOTE: to use any of these drivers with Microsoft Excel X, you must also download Microsoft Query, a free download from Microsoft. It is available here or by visiting www.microsoft.com and searching for "Query X". Microsoft Office 2004 and 2008 include Query - it does not need to be downloaded separately.
If you have any questions during your evaluation of the drivers, please visit our
support page, or e-mail us at
support@actualtechnologies.com.
Recent Changes
Actual ODBC Driver for SQL Server v2.9
It is recommended that all users of v2.8 or earlier upgrade to this new release. This release includes the following new features:
- Fixed a problem with returning null values (2.9b)
- Added support for MS SQL Server 2008 (when used with FileMaker 10 ESS)
- Fixed non-English truncation with SCC MediaGrid
- Several minor bug fixes
Actual ODBC Driver for Open Source Databases v2.9
It is recommended that all users of v2.8 or earlier upgrade to this new release. This release includes the following new features:
- Fixed a resource deallocation conflict with FileMaker Server (2.9b)
- Several minor bug fixes
Actual ODBC Driver for Oracle v2.9d
It is recommended that all users of v2.8 or earlier upgrade to this new release. This release includes the following new features:
- Added support for Rosetta applications (when used with OCI libraries)
- Several minor bug fixes
Actual ODBC Driver for Access v1.9
It is recommended that all users of v1.8 upgrade to this new release. This release includes the following new features:
- Added support for SQL 92 inner join syntax
- Several minor bug fixes
Actual ODBC Driver for OpenBase v2.2
It is recommended that all users of v2.1 or earlier upgrade to this new release. This release includes the following new features:
- Added support for inserting, updating and fetching BLOB types
- Fixed problem with text containing quote marks
- Improved consistency with Leopard UI
- Several minor bug fixes
Database Compatibility
Actual SQL Server:
- SQL Server 6.5 or later, including all editions of SQL Server 2008
- Sybase ASE 12 or later
- Sybase ASA / iAnywhere 5.5 or later
Actual Oracle:
- Oracle 7.3.4 or later, including Oracle 11g
Actual Open Source Databases:
- MySQL 3.23 or later
- PostgreSQL 7.3 or later
- SQLite 3.0 or later
Actual Access:
- MS Access 97 or later
- Tab delimited text files
- Comma separated variable (CSV) files
- Excel 97 or later spreadsheet files
Actual OpenBase:
- OpenBase 8.0 or later
Mac OS X Compatibility
- Mac OS X 10.2.8 or later (including 10.5)
- PowerPC and Intel Macs
