跪求 sql 访问其他服务器
来源:百度知道 编辑:UC知道 时间:2024/06/03 09:32:49
江湖豪侠,请问怎么sql语句连接呢?
必须要先连接上才能查询.
一种是用企业管理器连接,你只要SQL SERVER组里面注册一下就行了.
另一种是用程序连接,下面是用ASP连接的代码:
<%
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName,ConnStr,Conn
SqlDatabaseName = "xxx" 'SQL数据库名
SqlUsername = "xxx" 'SQL数据库用户名
SqlPassword = "xxx" 'SQL数据库用户密码
SqlLocalName = "xxx" 'SQL主机IP地址(本地可用“127.0.0.1”或“(local)”,非本机请用真实IP)
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错,请检查连接字串。"
Response.End
End If
sub CloseConn()
conn.clo