Article ID: 941526 - View products that this article applies to.
In a Microsoft .NET Framework-based application, the Failover Partner connection string attribute cannot connect to a mirror partner server by using the SQL Native Client OLE DB provider and the SQL Native Client ODBC driver.
Consider the following scenario:
This problem occurs because the SQL Native Client OLE DB provider and the SQL Native Client ODBC driver do not correctly translate the alias to an IP address before the .NET Framework-based application tries to connect to the mirror partner server.
To work around this problem, use one of the following methods.
For more information about database mirroring, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms366348.aspxThe product documentation does not indicate how to use an alias name in the Failover Partner connection string attribute.
You can specify the mirror partner server by using the Failover Partner attribute. The simplest way to determine the server instance is by its system name. For example, you can use the following format:
server_name [\SQL_Server_instance_name]Or, you can use the IP address and the port number in the Failover Partner attribute.
Article ID: 941526 - Last Review: December 3, 2007 - Revision: 1.1
Contact us for more help