asp连接sql问题,帮忙看看
set conn=Server.CreateObject( "ADODB.Connection ")
set studentRS=Server.Createobject( "ADODB.Recordset ")
conn.open "DSN=student;UID=xa;PWD=xa "
studentRS.open "select * from student ",conn
我这样可以查询表student里面的数据显示的页面,但是把conn.open "DSN=student;UID=xa;PWD=xa "替换成
conn.open "Driver={SQL Server};DateBase=myasp;Server=(local);UID=xa;PWD=xa "就老提示查询语句中的student对象不存在,是怎么回事啊?
[解决办法]
set conn=Server.CreateObject( "ADODB.Connection ")
conn.open( "driver={sql server};server=服务器名或ip地址;uid=用户名;pwd=密码;database=cldd ")
sql= "SELECT * FROM student "
set rs=server.createobject( "adodb.recordset ")
rs.open sql,conn,1,1
我通常这么写,是好用的,望参考
