急、跪求asp连接sqlserver的问题
我在服务器A(服务器A安装了sqlserver数据库),用iis建了一个web网站,连接数据库的方式:
<%
Function GetSQLServerConnection( Computer, UserID, Password, Db )
Dim Params, conn
If IsObject(conn) = True Then Exit Function
Set GetSQLServerConnection = Nothing
Params = "Provider=SQLOLEDB.1"
Params = Params & ";Data Source=" & Computer
Params = Params & ";User ID=" & UserID
Params = Params & ";Password=" & Password
Params = Params & ";Initial Catalog=" & Db
Set conndiary = Server.CreateObject("ADODB.Connection")
conn.Open Params
Set GetSQLServerConnection = conn
End Function
Function DBConnEnd()
On Error Resume Next
conn.Close
Set conn = Nothing
End Function
Set conn = GetSQLServerConnection( "localhost","sa", "sa", "abc" )
%>
以上连接方式,在服务器A的web网站,能正常访问数据库...
然后,我想利用服务器B中的web网站(服务器B没有安装sqlserver数据库),访问服务器A的数据库,连接数据库存代码和上面一样,仅以下不同:
Set conn = GetSQLServerConnection( "200.23.25.10","sa", "sa", "abc" )
很明显,我只能用A服务器的ip地址来连接其数据库.
可是,服务器B所在的web网站,无论如何也连接不上服务器A的数据库,请各位高手指点迷津~~~~~