经典asp和sql数据库azure

Question

我们正在迁移到Azure和有一个应用程序，仍然在经典的ASP。我们已经将它需要与之通信的数据库迁移到Azure中的SQL数据库。

ConnString = "DRIVER=SQL Server Native Client 10.0;Server=servername.database.windows.net,1433;Database=azuredb;UID=user@serve‌ rname;PWD=password;Encrypt=yes;TrustServerCertificate=no;" 

Set Conn = CreateObject("ADODB.Connection") 
Conn.Open ConnString 
set rs=Server.CreateObject("ADODB.recordset") 
SQL = "SELECT * from table" 
rs.Open( SQL ) 

SQL Server Native Client 10.0;Server=servername.database.windows.net,1433;
Database=azuredb;UID=user@serve‌ rname;PWD=password;Encrypt=yes;
TrustServerCertificate=no;

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC Driver Manager] 
Data source name not found and no default driver specified

我们在一个运行Server2008 R2的VM中运行这个

Answer 1

答案是您必须安装SQL本机客户端。

http://go.microsoft.com/fwlink/？LinkId=239648&clcid=0x409