odbc.asp

来自「asp的新闻网站」· ASP 代码 · 共 19 行

<%
'数据库连接
Dim DbServerName '数据库服务器IP
Dim DbName '数据库名称
Dim Uid '用户
Dim Pwd '密码

DbServerName="172.17.6.222"
DbName="newsinfo"
Uid="homenewsinfouser"
Pwd="homenewsinfopwd"

set conn=server.CreateObject("adodb.connection")
conn.provider="sqloledb"
conn.ConnectionString = "driver={SQL Server};server=" & DbServerName & ";uid=" & Uid & ";Pwd=" & Pwd & ";database=" & DbName
conn.open
%>