VB,sql server 7.0 问题

[goldentree]

我新装的sql7 server，odbc也test正确，不知为什么在server端用VB RDO 联时出现
"the cursor was not declared" error，在client端却无此问题
而以前我用sql 6.5与VB联时server端也无此问题
其实我并没定义crusor.

[Chen_Lin]

用ADO吧。

[huitor]

别用老掉牙的rdo了.

[AlanChen]

我曾遇到你同样的问题，如下可解决
sql1 = "declare my_cur scroll cursor for select * from dqry;"
sql2 = "open my_cur;"
sql3 = 你的sql语句
sql4 = "close my_cur;"
With MSRDC1
.Connect = "....."
.DataSourceName = "...."
.SQL = sql1 & sql2 & sql3 & sql4
.CursorDriver = rdUseOdbc
.Refresh
End With

[AlanChen]

我曾遇到你同样的问题，如下可解决
sql1 = "declare my_cur scroll cursor for select * from table;"
sql2 = "open my_cur;"
sql3 = 你的sql语句
sql4 = "close my_cur;"
With MSRDC1
.Connect = "....."
.DataSourceName = "...."
.SQL = sql1 & sql2 & sql3 & sql4
.CursorDriver = rdUseOdbc
.Refresh
End With

[goldentree]

在client/server应用vb，我觉得rdo比dao快很多，我只在ASP中用ado,
不知在client/server中ado速度能比rdo快吗
另:AlanChen
我的程序在client端运行并不问题，只是在server端有此问题，且是sql7.