关于sql 2000 server 查询的问题.
<%
set conn = server.CreateObject("adodb.connection")
conn.open"introduction","student",3,3
set conn = server.CreateObject("adodb.recordset")
set rs = conn.execute("select *from introduction ")?
%>
打?处总是出错.
数据源是student,表名是introduction.
谢谢!
conn.open <connectionString> !!
对于SQL SERVER来说：connectionString一般是这样的：
provider=sqloledb;data source=databaseServerName;initial catalog=databaseName;user id=sa;password=;
set conn = server.CreateObject("adodb.connection")
conn .ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=databasename;Data Source=datasource"
conn.Open
set conrs = server.CreateObject("adodb.recordset")
set rs = conrs.execute("select * from introduction ")
我认为数据连接和记录集不要重名得好。
