ODBC Administrator is a 32-bit utility in the Mac OS X operating system for administering ODBC, which enables interaction with ODBC-compliant data sources.Features include connection pooling, trace log creation, and ODBC driver management, among other administration features. Although Apple started including the underlying iODBC libraries in Mac OS X 'Jaguar' (10.2.x), and has continued to do. I've got postges 9.4 installed on Mac OS X 10.10.3 (Yosemite) I have access to it from psql and I have set up and filled a database I now want to access via ODBC - all on the localhost, no remote access.
Our software library provides a free download of Actual ODBC Driver for Access 3.2 for Mac. The actual developer of this free Mac application is Actual Technologies. The program is included in System Tools. This Mac download was scanned by our antivirus and was rated as virus free. The latest installation package takes up 65 MB on disk.
- Actual Technologies today announce that the latest versions of the Actual ODBC Drivers work great with Mac OS X 10.10 'Yosemite'. The latest Actual ODBC Pack installer should be run after upgrading to Yosemite to ensure compatibility between your application and the drivers. October 24, 2013.
- I'm working on Mac OS X Yosemite with ms office 2011 and I'm trying to connect my Excel Workbook to a sql-database. This has to be done through vba as later on I want to read data from the sql-database as well as write data to the database. I couldn't find a way to establish a connection to that database.
The ODBC drivers for Linux and macOS support AlwaysOn Availability Groups. For more information about AlwaysOn Availability Groups, see:
You can specify the availability group listener of a given availability group in the connection string. If an ODBC application on Linux or macOS is connected to a database in an availability group that fails over, the original connection is broken and the application must open a new connection to continue work after the failover.
The ODBC drivers on Linux and macOS iterate sequentially through all IP addresses associated with a DNS hostname if you are not connecting to an availability group listener, and multiple IP addresses are associated with the hostname.
If the DNS server's first returned IP address is not connectable, these iterations can be time consuming. When connecting to an availability group listener, the driver attempts to establish connections to all IP addresses in parallel. If a connection attempt succeeds, the driver discards any pending connection attempts.
Note
Because a connection can fail due to an availability group failover, implement connection retry logic; retry a failed connection until it reconnects. Increasing connection timeout and implementing connection retry logic increases the chance of connecting to an availability group.
Connecting With MultiSubnetFailover
Always specify MultiSubnetFailover=Yes when connecting to a SQL Server 2012 (11.x) availability group listener or SQL Server 2012 (11.x) Failover Cluster Instance. MultiSubnetFailover enables faster failover for all Availability Groups and failover cluster instance in SQL Server 2012 (11.x). MultiSubnetFailover also significantly reduces failover time for single and multi-subnet AlwaysOn topologies. During a multisubnet failover, the client attempts connections in parallel. During a subnet failover, the driver aggressively retries the TCP connection.
The MultiSubnetFailover connection property indicates that the application is being deployed in an availability group or Failover Cluster Instance. The driver tries to connect to the database on the primary SQL Server instance by trying to connect to all the IP addresses. When connecting with MultiSubnetFailover=Yes, the client retries TCP connection attempts faster than the operating system's default TCP retransmit intervals. MultiSubnetFailover=Yes enables faster reconnection after failover of either an AlwaysOn Availability Group or an AlwaysOn Failover Cluster Instance. MultiSubnetFailover=Yes applies to both single- and multi-subnet Availability Groups and Failover Cluster Instances.
Use MultiSubnetFailover=Yes when connecting to an availability group listener or Failover Cluster Instance. Otherwise, your application's performance can be negatively affected.
Note the following when connecting to a server in an availability group or Failover Cluster Instance:
- Specify MultiSubnetFailover=Yes to improve performance when connecting to a single subnet or multi-subnet Availability Group.
- Specify the availability group listener of the availability group as the server in your connection string.
- You cannot connect to a SQL Server instance configured with more than 64 IP addresses.
- Both SQL Server Authentication or Kerberos Authentication can be used with MultiSubnetFailover=Yes without affecting the behavior of the application.
- You can increase the value of loginTimeout to accommodate for failover time and reduce the application's connection retry attempts.
- Distributed transactions are not supported.
If read-only routing is not in effect, connecting to a secondary replica location in an availability group fails in the following situations:
- If the secondary replica location is not configured to accept connections.
- If an application uses ApplicationIntent=ReadWrite and the secondary replica location is configured for read-only access.
A connection fails if a primary replica is configured to reject read-only workloads and the connection string contains ApplicationIntent=ReadOnly.
Specifying Application Intent
The keyword ApplicationIntent can be specified in your connection string. The assignable values are ReadWrite or ReadOnly. The default is ReadWrite.
When ApplicationIntent=ReadOnly, the client requests a read workload when connecting. The server enforces the intent at connection time, and during a USE database statement.
The ApplicationIntent keyword does not work with legacy read-only databases.
Targets of ReadOnly
When a connection chooses ReadOnly, the connection is assigned to any of the following special configurations that might exist for the database:
- A database can allow or disallow read workloads on the targeted Always On database. This choice is controlled by using the ALLOW_CONNECTIONS clause of the PRIMARY_ROLE and SECONDARY_ROLE Transact-SQL statements.
If none of those special targets are available, the regular database is read from.
The ApplicationIntent keyword enables read-only routing.
Read-Only Routing
Read-only routing is a feature that can ensure the availability of a read-only replica of a database. To enable read-only routing, all of the following apply:
- You must connect to an Always On Availability Group availability group listener.
- The ApplicationIntent connection string keyword must be set to ReadOnly.
- The Availability Group must be configured by the database administrator to enable read-only routing.
Multiple connections each using read-only routing might not all connect to the same read-only replica. Changes in database synchronization or changes in the server's routing configuration can result in client connections to different read-only replicas. You can ensure that all read-only requests connect to the same read-only replica. Ensure this sameness by not passing an availability group listener to the Server connection string keyword. Instead, specify the name of the read-only instance.
Read-only routing may take longer than connecting to the primary. The longer wait is because read-only routing first connects to the primary, and then looks for the best available readable secondary. Due to these multiple steps, you should increase your login timeout to at least 30 seconds.
ODBC Syntax
Two ODBC connection string keywords support AlwaysOn Availability Groups:
- ApplicationIntent
- MultiSubnetFailover
For more information about ODBC connection string keywords, see Using Connection String Keywords with SQL Server Native Client.
The equivalent connection attributes are:
- SQL_COPT_SS_APPLICATION_INTENT
- SQL_COPT_SS_MULTISUBNET_FAILOVER
For more information about ODBC connection attributes, see SQLSetConnectAttr.
Iphoto for el capitan canada 10. An ODBC application that uses AlwaysOn Availability Groups can use one of two functions to make the connection:
Function | Description |
---|---|
SQLConnect Function | SQLConnect supports both ApplicationIntent and MultiSubnetFailover via a data source name (DSN) or connection attribute. |
SQLDriverConnect Function | SQLDriverConnect supports ApplicationIntent and MultiSubnetFailover via DSN, connection string keyword, or connection attribute. |
See Also
May 20, 2020
Actual Announces FileMaker 19 Compatibility
Actual Technologies today announced that the latest versions of the Actual ODBC Drivers are recommended for use with Claris FileMaker 19. Actual ODBC Pack version 5 features full compatibility with FileMaker 19, Microsoft Excel 2016 (part of Microsoft Office 365), and Mac OS Catalina. Version 5 licenses are available at a discount for version 4 users. The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
October 7, 2019
Actual ODBC is Compatible with Catalina
The latest Actual ODBC Pack is compatible with Apple's latest Mac OS 10.15 Catalina. Version 5 features full compatibility with FileMaker 18, Microsoft Excel 2016 (part of Microsoft Office 365), and Mac OS Catalina. The new version also includes numerous performance and stability enhancements, as well as support for future versions of Mac OS. Version 5 licenses are available at a discount for version 4 users. The Actual ODBC Pack installer is available now from the Actual Technologies website.
September 4, 2019
Actual Announces Actual ODBC Pack 5.0
Actual Technologies today announced the introduction of version 5.0 of their acclaimed ODBC drivers. Version 5 features full compatibility with FileMaker 18, Microsoft Excel 2016 (part of Microsoft Office 365), and Mac OS Mojave. The new version also includes numerous performance and stability enhancements, as well as support for future versions of Mac OS. Version 5 licenses are available at a discount for version 4 users. The Actual ODBC Pack installer is available now from the Actual Technologies website.
May 22, 2019
Actual Announces FileMaker 18 Compatibility
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are recommended for use with FileMaker 18. The upgrade is free for users who already have a Version 4 license key (version 3 users can upgrade at a discount). The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
May 15, 2018
Actual Announces Actual ODBC Pack 4.2.0 for FileMaker 17
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are recommended for use with FileMaker 17. Best macos for macbook air mid 2011. How to format wd my book for mac el capitan. The upgrade is free for users who already Have a Version 4 license key (version 3 users can upgrade at a discount). The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
May 9, 2017
Actual Announces Actual ODBC Pack 4.1.0 for FileMaker 16
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are recommended for use with FileMaker 16. The upgrade is free for users who already Have a Version 4 license key (version 3 users can upgrade at a discount). The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
August 26, 2016
Actual ODBC Compatible with 64-bit Excel
Microsoft has released a 64-bit version of Excel 2016 for Mac (version 15.25). This new version of Excel requires the latest versions of the Actual ODBC Pack drivers in order to avoid a crash. The Actual ODBC Pack installer is available now from the Actual Technologies website.
Odbc Driver For Mac Yosemite 10
May 10, 2016
Actual Announces ODBC Pack 4.0
Actual Technologies today announced the introduction of version 4.0 of their acclaimed ODBC drivers. Version 4 features full compatibility with FileMaker 15, Microsoft Excel 2016, and Mac OS X El Capitan. The new version also includes numerous performance and stability enhancements, as well as new features like support for .XLSX files with the Actual Access driver. The Actual ODBC Pack installer is available now from the Actual Technologies website.
May 10, 2016
Actual ESS Adapter Now Available
Actual Technologies today released a new product for connecting FileMaker solutions to Postgres and IBM DB2 databases. Developers already use Actual Technologies ODBC drivers for MySQL, Oracle, and Microsoft SQL Server with the 'External SQL Sources' (ESS) feature of FileMaker. The Actual ESS Adapter broadens the types of databases which can be used with ESS. Licenses are free for Mac OS X, and start at $39.95 per PC for Windows users. The Actual ESS Adapter installer is available now from the Actual Technologies website.
September 30, 2015
Actual Announces 'El Capitan' Compatibility for Actual ODBC Pack
Odbc Driver For Macos
Actual Technologies today announced that the latest versions of the Actual ODBC Drivers are compatible with Mac OS X 10.11 'El Capitan'. The latest Actual ODBC Pack installer should be run after upgrading to El Capitan to ensure compatibility between your application and the drivers.
July 12, 2015
Actual Announces Support for Microsoft Excel 2016
Odbc Driver For Mac Yosemite 10
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are are compatible with Excel 2016. The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
May 12, 2015
Actual Announces Actual ODBC Pack 3.3.0 for FileMaker 14
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are recommended for use with FileMaker 14. The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
October 16, 2014
Actual Announces Yosemite Compatibility for Actual ODBC Pack
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers work great with Mac OS X 10.10 'Yosemite'. The latest Actual ODBC Pack installer should be run after upgrading to Yosemite to ensure compatibility between your application and the drivers.
October 24, 2013
Actual Announces Actual ODBC Pack 3.2 for Mavericks
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers work great with Mac OS X 10.9 'Mavericks'. The latest Actual ODBC Pack installer should be run after upgrading to Mavericks to ensure compatibility between your application and the drivers.
July 25, 2012
Actual ODBC Drivers Have Gatekeeper Support on Mountain Lion
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers work great with Mac OS X 10.8 'Mountain Lion'. The Actual ODBC Pack installer is built to work with the new Gatekeeper security feature of Mountain Lion.
April 4, 2012
Actual Announces Actual ODBC Pack 3.1 for FileMaker 12
Actual Technologies today released the Actual ODBC Pack version 3.1. The drivers fully support the new 64-bit FileMaker Server 12 released today. FileMaker 12 includes support for Microsoft SQL Server 2008, Oracle 11g and MySQL 5.1. You can use our drivers with any of the databases supported by FileMaker. Download and try the new drivers today.
July 20, 2011
![Odbc Driver For Mac Yosemite Odbc Driver For Mac Yosemite](/uploads/1/2/6/6/126615606/266666064.png)
Actual ODBC drivers on Lion!
The latest Actual ODBC Pack version 3.0 includes support for Apple's Mac OS X 10.7 'Lion'. The drivers also work great with Microsoft Excel 2011. Visit our download page to get running with the latest drivers.
March 9, 2010
Actual Announces Actual ODBC Pack 3.0 for FileMaker 11
Actual Technologies today released the Actual ODBC Pack version 3.0. The drivers now fully support 64-bit applications, such as Apache / PHP on Snow Leopard. The new driver versions also support the latest External SQL Source (ESS) features of FileMaker 11. FileMaker 11 includes support for Microsoft SQL Server 2008, Oracle 11g and MySQL 5.1. You can download and try the new drivers today.
January 5, 2009
Actual ODBC Supports Latest FileMaker Pro 10 External SQL Sources
Actual Technologies today released the Actual ODBC Pack version 2.9. The new driver versions support the latest External SQL Source (ESS) features of FileMaker 10. FileMaker 10 now includes support for Microsoft SQL Server 2008, Oracle 11g and MySQL 5.1. You can download and try the new drivers today.
July 10, 2007
Actual ODBC Supports New FileMaker Pro 9 External SQL Sources
Actual Technologies today released the Actual ODBC Pack version 2.7, a set of database drivers for Mac OS X. The drivers are tailored for use with the new External SQL Source (ESS) feature of FileMaker Pro 9. With Actual ODBC, FileMaker Pro 9 users can view and update live data in Microsoft SQL Server, Oracle and MySQL databases without writing SQL code. The drivers are available starting at $30 per license. To purchase the software or download an evaluation copy, please visit http://www.actualtech.com.
January 9, 2006
Actual releases ODBC Pack 2.0 drivers
Actual Technologies has released the Actual ODBC Pack 2.0, a suite of ODBC drivers designed to connect to popular databases. The new drivers are distributed as Universal Binaries for compatibility with both PowerPC Macs as well as Intel-based Macs, and are designed specifically for Mac OS X.
Each member of the ODBC pack connects Excel X to a database back-end, without the need for programming knowledge while allowing users to import from FileMaker Pro. Supported databases include SQL Server/Sybase, Oracle, MySQL/PostgreSQL and Microsoft Access.
Each database driver is available for $30, and requires Mac OS X 10.2.4 or later.