php tag标签功能:asp中连接数据库的时候怎么设置"测试服务器"啊?我怎么老是连接不上?请教各位
来源:百度文库 编辑:中科新闻网 时间:2024/06/04 05:43:16
access
??ASP连接数据库,你是要连接ACCESS还是SQL?
连接方法如下:
ACCESS:
<%
dim conn,connstr,dbfile
dbfile="XXX.MDB"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(dbfile)
conn.Open connstr
%>
SQL:
<%
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
SqlDatabaseName = "XXX"
SqlPassword = ""
SqlUsername = "USERNAME"
SqlLocalName = "(local)"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
%>
到这里看看吧
以前有人问过的
http://zhidao.baidu.com/question/781582.html
ASP连接数据库,你是要连接ACCESS还是SQL