我用的是vb+sqlsever2000+win2k
code为
dim cnn as new adodb.connection
dim rst as new adodb.recordsetcnn.open "provider=sqloledb;data source=blue;initial catalog=bg;
Integrated Security=sspi"rst.open "gkt",cnn,adOpenStatic,adLockOptimistic gkt表中有5条记录
可是rst.recordcout返回记录数为-1
code为
dim cnn as new adodb.connection
dim rst as new adodb.recordsetcnn.open "provider=sqloledb;data source=blue;initial catalog=bg;
Integrated Security=sspi"rst.open "gkt",cnn,adOpenStatic,adLockOptimistic gkt表中有5条记录
可是rst.recordcout返回记录数为-1
dim cnn as new adodb.connection
dim rst as new adodb.recordsetcnn.open "provider=sqloledb;data source=blue;initial catalog=bg;
Integrated Security=sspi"
Sql = "SELECT * FROM gkt"
rst.open sql,cnn,adOpenStatic,adLockOptimistic
rst.open sql,cnn,adOpenStatic,adLockOptimistic 这样才能打开你的gkt表,而ADO是用SQL语句来选择这个表中的所有记录的,再看你的代码:rst.open "gkt",cnn,adOpenStatic,adLockOptimistic 直接就写一个gkt,你如果把这个字符串"gkt"当做SQL 语句来执行的话,那么SQL SERVER是一定不认识的了!