Microsoft.jet.oledb.4.0 Drivers For Mac

понедельник 27 январяadmin
-->

The ODBC drivers for Linux and macOS support AlwaysOn Availability Groups. For more information about AlwaysOn Availability Groups, see: Mac osx high sierra registry cleaner maintenance tool.

GermanMicrosoft released a fix for the Microsoft JET Database Engine. The error message is, “Unexpected error from external database driver (1). Jet.OLEDB.4.0 provider, use the Microsoft Access Database Engine (ACE) Provider. MacOS, Office, Security, Software, Update, Virtualization, Windows.

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:

  1. Axia ip audio driver for mac. If the secondary replica location is not configured to accept connections.

  2. 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 staps, 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.

An ODBC application that uses AlwaysOn Availability Groups can use one of two functions to make the connection:

FunctionDescription
SQLConnect FunctionSQLConnect supports both ApplicationIntent and MultiSubnetFailover via a data source name (DSN) or connection attribute.
SQLDriverConnect FunctionSQLDriverConnect supports ApplicationIntent and MultiSubnetFailover via DSN, connection string keyword, or connection attribute.

See Also

In order to get the most out of your new MacVidCards GPU you may need to install new drivers for your current version of OS X. Please note that AMD GPUs do not require additional drivers; they are built directly into OS X.
Nvidia GPUs receive driver updates soon after each version update of OS X. Only one driver is released by Nvidia and it includes support for all of their modern GPUs. You will not find individually named Nvidia drivers for OS X, they are all titled 'Quadro & Geforce Mac OS X Driver Release xxx.xx.xxxxx'. The following list includes links to current and past Nvidia driver releases.
Some releases of OS X have multiple driver releases. In the list below these are differentiated by a build number in parentheses, and are ordered oldest to newest, left to right. Refer here to check your OS X build number and install the driver that matches both your version of OS X and​ your build number.
Nvidia cards also require a CUDA driver to enable CUDA support. The CUDA driver archive can be found here. Install the latest CUDA driver that works with your currently installed version of OS X to enable CUDA support.
  • 10.6.8 256.02.25f01
  • 10.7.3 270.00.00f01
  • 10.7.4 270.00.00f06
  • 10.7.5295.00.05f03
  • 10.8.1 304.00.00f20
  • 10.8.2 304.00.05f02
  • 10.8.3 313.01.01f03
  • 10.8.4 313.01.02f01
  • 10.8.5313.01.03f01 (12F37) and 313.01.03f02 (12F45) 313.01.04f02 (12F2501) 313.01.04f04 (12F2518) 313.01.04f05(12F2542) 313.01.04f05 (12F2560) 313.01.04f06
  • NOTE: ​GTX780Ti & GTX Titan Black require 10.9.2 or later and Web Driver
  • 10.9.2 331.01.01f01 (13C64), 331.01.01f02 (13C64), and 331.01.01f04 (13C1021)
  • 10.9.3 334.01.01f01 (13D65)
  • 10.9.4 334.01.02f02 (13E28)
  • 10.9.5334.01.03f01 (13F34) 334.01.03f02 (13F1066) 334.01.03f03(13F1077) 334.01.03.f04 (13F1096) 334.01.03.F05(13F1112) (13F1134) 334.01.03f06 (13F1507) 334.01.03f07 (13F1603) 334.01.03f08 (13F1712) 334.01.03f09 (13F1808) 334.01.03f10
  • (13F1911) 334.01.03f11
  • NOTE: GTX750Ti GTX950 GTX960 GTX970 GTX980 GTX980 Ti and Titan X REQUIRE 10.10 or later and the web driver.
  • 10.10 343.01.01f01 (14A389), 343.01.01f02 (14A389), and 343.01.01f03 (14A389)
  • 10.10.1 343.01.02f01 (14B25)
  • 10.10.2 343.02.02f02 (14C109), 343.02.02f03 (14C1510) 343.02.02f04 (14C1514 )
  • 10.10.2 346.01.01f01 (14C1514)
  • 10.10.3 (14D Beta) 346.01.02b01(14D131) 346.01.02f01 (14D136) 346.01.02f02 (14D136) 346.01.02f03(14D136)346.01.02f04
  • 10.10.4 (14E Beta) 346.01.03b01 (14E46)346.01.03f01 (14E46) 346.02.02f03
  • 10.10.5 (14F Beta) 346.02.03b01 (14F27) 346.02.03f01 (14F1021) 346.02.03f02 (14F1505) 346.02.03f03 (14F1509) 346.02.03f04
  • 10.10.5 (14F1605) 346.02.03f05 (14F1713) 346.02.03f06 (14F1808) 346.02.03f07 (14f1909) 346.02.03f08 (14F1912) 346.02.03f09 (14F2009) 346.02.03f10​ (14F2109)346.02.03f11​ ​(14F2315)346.02.03f12 (14F2411)346.02.03f13
  • 10.10.5 (14F2511)346.02.03f14
  • 10.11 (15A Beta) 346.03.01b07(15A284) 346.03.02f02
  • 10.11.1 (15B42) 346.03.03f01 (15B42) 346.03.03f02
  • 10.11.2 (15C50) 346.03.04f01 (15C50) 346.03.04F02
  • 10.11.3 (15D21) 346.03.05f01 (15D21) 346.03.05f02
  • 10.11.4 (15E Beta) 346.03.06b0​(15E) 346.03.06b1 (15E65) 346.03.06f01
  • 10.11.5 (15F18b Beta) 346.03.10b01 BETA (15F24b) 346.03.10b01(15F34) 346.03.10f01(15F34) 346.03.10f02
  • 10.11.6 (15G12a Beta) 346.03.15b01 FINAL (15G31) 346.03.15f01 (15G31) 346.03.15f02 (15G1004)346.03.15f03
  • (15G1108) 346.03.15f04(15G1212) 346.03.15f05 (15G1217)346.03.15f06 (15G1421)346.03.15f07 (15G1510) 346.03.15f08
  • (15G1611) 346.03.15f09 (15G17023)346.03.15f10(15G18013) 346.03.15f11 (15G20015) 346.03.15f12
  • (15G20015) 346.03.15f14(15G21013) 346.03.15f15(15G22010)346.03.15f16
  • 10.12 (16A201w Beta) 367.05.10.05b03 (16A239j, 16A254g, 16A238m, etc) 367.05.10.05b07 367.10.10.05b01
  • ​10.12 (16A323) 367.15.10.05f01
  • 10.12.1 (16B2555) 367.15.10.15f01(16B2657) 367.15.10.15f03(16B2659) 367.15.10.15f03
  • 10.12.2 (16C67) 367.15.10.25f01(16C68) 367.15.10.25f02
  • 10.12.3 (16D32) 367.15.10.35f01
  • 10.12.4 (16F73) 378.15.10.45f01
  • ADDED PASCAL DRIVER - 10.12.4 (16E195) 378.05.05.05f01(16E195)378.05.05.05f02
  • 10.12.5 (16F73) 378.05.05.15f01
  • 10.12.6 (16G29) 378.05.05.25f01(16G1036)378.05.05.25f03 (16G1114) 378.05.05.25f04(16G1212) 378.05.05.25f06
  • (16G1314)378.05.05.25f07 (16G1408)378.05.05.25f09(16G1510)378.05.05.25f10 (16G1818)378.05.05.25f11
  • (16G1710)(16G2128​)378.05.05.25f18 (16G2136) 378.05.05.25f19
  • 10.13 (17A365) 378.10.10.10.15.114 (17A405)378.10.10.10.15.117(17A405)378.10.10.10.15.120
  • (17A405)
  • 10.13.1 (17B48) 378.10.10.10.20.107 (Do this from 121 driver to avoid Panic Loop or delete Startup Web kext)
  • (17B1002)378.10.10.10.20.108 (17B1003)
  • 10.13.2(17C88)378.10.10.10.25.102(17C89)378.10.10.10.25.103 (17C205) 378.10.10.10.25.104(17C2120)378.10.10.10.25.105 ​(17C2205)378.10.10.10.25.106
  • 10.13.3 (17D47)387.10.10.10.25.156(17D2047)387.10.10.10.25.157(17D102)387.10.10.10.25.158(17D2102)387.10.10.10.25.159
  • 10.13.4 (17E199)387.10.10.10.30.106 10.13.4 (17E202)387.10.10.10.30.107
  • 10.13.5 (17f77)387.10.10.10.35.106
  • 10.13.6 (17g65)387.10.10.10.40.105 10.13.6 (17G3025)387.10.10.10.40.10810.13.6 (17G4015) 387.10.10.10.40.113
  • 10.13.6 (17G5019)387.10.10.10.40.118 10.13.6 (17G5019)387.10.10.10.40.12210.13.6 (17G6029)387.10.10.10.40.123
  • 10.13.6 (17G6030) 387.10.10.10.40.12710.13.6 (17G7024)387.10.10.10.40.12810.13.6 ​(17G8030)387.10.10.10.40.130
  • 10.13.6 (17G8037)387.10.10.10.40.131 10.13.6 (17G9016)387.10.10.10.40.132
  • 10.13.6 (17G10021)