asp远程访问sql server数据库

<%
set conn=server.createobject("adodb.connection")
conn.connectionstring="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=210.76.209.130;DATABASE=databasename;UID=sa;PWD=password;"
conn.open 
%>

其中  210.76.209.130 就是远程服务器的IP

转载于:https://www.cnblogs.com/tianlangshu/archive/2011/03/20/1989597.html