尽量用下边的方式,需要一个ODBC数据源,载控制面板里 set conn = Server.CreateObject("adodb.Connection") conn.open "Database=haier;uid=3E_user;pwd=sa;DSN=haier" set record = server.CreateObject("adodb.recordset") 'response.Write(sql) record.open sql,conn
用recordset conn="Provider=SQLOLEDB.1;Pwd=密码;Persist Security Info=True;UID=用户;Initial Catalog=数据库名;Data Source=服务器名" set rs=server.createobject("adodb.recordset") rs.open "select * from 表名",conn,1,3 …… rs.updatebatch rs.close set rs=nothing
1)connstr="Driver={SQL Server};Server=服务器名;UID=用户名;PWD=密码;Database=数据库名"
2)connStr="Provider=SQLOLEDB.1;Password=密码;Persist Security Info=True;User ID=用户名;Initial Catalog=数据库名;Data Source=服务器名"
set conn = Server.CreateObject("adodb.Connection")
conn.open "Database=haier;uid=3E_user;pwd=sa;DSN=haier"
set record = server.CreateObject("adodb.recordset")
'response.Write(sql)
record.open sql,conn
conn="Provider=SQLOLEDB.1;Pwd=密码;Persist Security Info=True;UID=用户;Initial Catalog=数据库名;Data Source=服务器名"
set rs=server.createobject("adodb.recordset")
rs.open "select * from 表名",conn,1,3
……
rs.updatebatch
rs.close
set rs=nothing