SQL Server Native Client 10 ODBC won't load library on Windows 2000

SQL Server Native Client 10 ODBC won't load library on Windows 2000

Could not load the setup or translator library.

http://www.experts-exchange.com/Microsoft/Applications/Q_24084897.html


上面那個外國人跟我遇到一樣的問題，

中文的訊息會顯示：不在有可用的提供者，請確認提供者安裝正確。

結果發現微軟有這個

os版本表

SQL Server Native Client Version	Supported Operating Systems
SQL Server Native Client (SNAC9)	Microsoft Windows 2000 Service Pack 4 or later Microsoft Windows Server 2003 or later Microsoft Windows XP Service Pack 1 or later Microsoft Windows Vista Microsoft Windows 2008 Server
SQL Server 2008 Native Client (SNAC10)	Microsoft Windows Server 2003 SP1 or later Microsoft Windows XP Service Pack 2 or later Microsoft Windows Vista Microsoft Windows 2008 Server

可連接資料庫版本

SQL Server Native Client Version	Supported SQL Server Versions
SQL Server Native Client (SNAC9)	Microsoft SQL Server 7.0 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Next SQL Server version
SQL Server 2008 Native Client (SNAC10)	Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Next two SQL Server versions

資料來源：http://blogs.msdn.com/b/sqlnativeclient/archive/2008/02/27/microsoft-sql-server-native-client-and-microsoft-sql-server-2008-native-client.aspx

結論…

以目前來看，還沒新版的Sql Server上市前

SNAC9 相容性 >>>> SNAC10相容性

囧…

沒事不要灌太新。