UC知道请问一下,哪位高手知道asp与SQL server 2000数据库怎么样连接，我要连接的语句!谢谢...我用的是DM。
来源：百度知道 编辑：UC知道 时间：2024/06/02 03:13:05
<%
set conn=Server.CreateObject("ADODB.Connection")
connstr="driver={SQL Server};Server=localhost; uid=aa;pwd=123;database=factory"
%>
<%
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from factory"
rs.Open sql,conn
%> 这样 连接 怎么有错啊！数据库名是factory表名是employee登录名是aa密码123怎么连接啊？
set conn=Server.CreateObject("ADODB.Connection")
connstr="driver={SQL Server};Server=localhost; uid=aa;pwd=123;database=factory"
%>
<%
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from factory"
rs.Open sql,conn
%> 这样 连接 怎么有错啊！数据库名是factory表名是employee登录名是aa密码123怎么连接啊？
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.open "driver={SQL Server};database=aspdata;Server=localhost;uid=sa;pwd="
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from 表名"
rs.Open sql,conn
response.write(rs("字段名"))
%>
用dm 点数据库用连接字符串"driver={SQL Server};database=aspdata;Server=localhost;uid=sa;pwd="
sql连接方法
Const SqlDatabaseName = "test" ' 数据库名字'
Const SqlPassword = "123" '数据库密码'
Const SqlUsername = "sa" '数据库帐户'
Const SqlLocalName = "127.0.0.1" '数据库地址'
'数据库连接函数'
Sub ConnectionDatabase
Dim ConnStr
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & &quo