sql本地和远程连接代码

来源：百度知道 编辑：UC知道 时间：2024/06/03 03:27:21
sql本地和远程连接代码，最好是DW自定义字符的方法。

Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName,ConnStr,Conn
SqlDatabaseName = "SQL数据库名"
SqlUsername = "SQL数据库用户名"
SqlPassword = "SQL数据库用户密码"
SqlLocalName = "SQL主机IP地址" '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

DW 是datawindow吗？

我猜测DW 是Dreamweaver

so我给出跟楼下一样的连接字符串

Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName,ConnStr,Conn
SqlDatabaseName = "SQL数据库名"
SqlUsername = "SQL数据库用户名"
SqlPassword = "SQL数据库用户密码"
SqlLocalName = "SQL主机IP地址" 'SQL主机IP地址（本地可用