高考问答结云套:求救!!!关于动态网页(asp)与数据库的问题?高手请进!
来源：百度文库 编辑：高考问答 时间：2024/04/18 20:57:33
<%
set conn=server.CreateObject("ADODB.Connection")
DBName="WebTeaching"
sql="Driver={SQL Server};server=(local);uid=sa;database="&DBName
conn.open(sql)
%>在这段代码中:如果我想加上登录密码为:password,这段代码应该如何写呀?
set conn=server.CreateObject("ADODB.Connection")
DBName="WebTeaching"
sql="Driver={SQL Server};server=(local);uid=sa;database="&DBName
conn.open(sql)
%>在这段代码中:如果我想加上登录密码为:password,这段代码应该如何写呀?
<%
set conn=server.CreateObject("ADODB.Connection")
DBName="WebTeaching"
sql="Driver={SQL Server};server=(local);uid=sa;pwd=password;database="&DBName
conn.open(sql)
%>
这样就行了
那要看你的数据是不是有密码。
<%
set conn=server.CreateObject("ADODB.Connection")
DBName="WebTeaching"
sql="Driver={SQL Server};server=(local);uid=sa;Password=XXXXX;database="&DBName
conn.open(sql)
%>
Set conn = Server.CreateObject "ADODB.Connection")
DBName="WebTeaching"
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;Server=(local);User ID=sa;Password=123456;Database=" &DBName& ";"
conn.Open connstr
sql="Driver={SQL Server};server=(local);uid=sa;pwd=password;database="&DBName
conn.open(sql)