CODEWITHSUNDEEP
sqlsql-serverwindows-xpcompatibilityodbc-sql-server-driver
Sajo Mathew
Sajo Mathew

Reputation: 363

Compatibility of SQL server native client 10.0 with Windows XP

Is the driver "SQL server native client 10.0" compatible with Windows XP?

Thanks

Upvotes: 1

Views: 17257

Answers (2)

user281806
user281806

Reputation: 1030

If for some legacy reason you need to install "ODBC Driver 11 for SQL Server" on Windows XP instead of version 10 (for example, because you need TDS 7.4 support, or you need to support SQL Server Availability Group listeners, etc.), but you receive the following error message: "Installation of this product failed because it is not supported on this operating system."

You can use the procedure from here to create an msodbcsql.msi file that will install on Windows XP: How to change the compatibility setting of msi

The steps are:

  1. Download the "ODBC Driver 11 for SQL Server" (the ODBC Driver for SQL Server 2012) from Microsoft. "ODBC Driver 11 for SQL Server"
  2. Obtain the Orca MSI Editor tool from Microsoft: Orca
  3. Run Orca
  4. Open the msodbcsql.msi file in Orca
  5. Select "Launch Condition" in the left pane.
  6. In the Right Pane, edit the the text: "(VersionNT = 600 AND ServicePackLevel >= 2) OR (VersionNT >= 601)" and change it to: "(VersionNT >= 500)"
  7. In Orca, Click Tools -> Options. On the Database tab, check "Copy embedded streams during 'Save As'"
  8. In Orca, choose File -> Save As and save the MSI file with a new name.

Upvotes: 0

Ed Harper
Ed Harper

Reputation: 21505

Yes - XP SP3 or later supports the v10.0 native client.

See http://www.microsoft.com/downloads/en/details.aspx?FamilyID=228de03f-3b5a-428a-923f-58a033d316e1&DisplayLang=en#SystemRequirements

Upvotes: 1

Related Questions