| 这种写法对不对？打开access数据库（第一行）和recordset对象可否这样使用？ ConnStr="Provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("../chap5/register.mdb") '参照表6-2的连接字符串 set myRec=Server.CreateObject ("ADODB.RecordSet") myRec.ActiveConnection=ConnStr '设定RecordSet的属性 'myRec.cursorlocation=aduseclient myRec.cachesize=5 myRec.open "select * from wjgg ",,1,3 '打开记录集 |
[此贴子已经被作者于2006-5-20 10:22:05编辑过]
2006-05-20 10:19
应该是错的
1:myRec.ActiveConnection=ConnStr
左边是Connection对象,右边是string
2:Connection对象没打开
应改成类似
set tempConnection=Server.CreateObject("ADODB.Connection")
tempConnection.Open ConnStr
set myRec=Server.CreateObject ("ADODB.RecordSet")
myRec.cachesize=5
myRec.open "select * from wjgg",tempConnection,1,3
的语句
2006-05-22 10:44
但是这样是可以的！
ConnStr="Provider=SQLOLEDB;data source=(local);initial catalog=northwind;user id=sa;password=;" '参照表6-2的连接字符串
set myRec=Server.CreateObject ("ADODB.RecordSet")
myRec.ActiveConnection=ConnStr
'设定RecordSet的属性
'myRec.cursorlocation=aduseclient
myRec.cachesize=5
myRec.open "select * from customers",,1,3 '打开记录集
2006-05-26 16:57
2006-05-27 09:01
