Private Sub Form_Load()
Dim i As Integer
Dim db As Connection
Set db = New Connection
db.Open SQLConnStr
* Set adoPrimaryRS = New Recordset
adoPrimaryRS.CursorLocation = adUseClient
SQL = "SELECT * FROM table where ID<>NULL"
adoPrimaryRS.Open SQL, db, adOpenDynamic, adLockBatchOptimistic
Set dgList.DataSource = adoPrimaryRS.Clone
dgList.Refresh
adoPrimaryRS.Close
mbDataChanged = False
End Sub
上面这段程序在别的机器(windowsXP)上没有问题,但在另一台机器(windows98)上*处报错:Run-time error'430':class does not support automation or does not support expected interface.
Dim i As Integer
Dim db As Connection
Set db = New Connection
db.Open SQLConnStr
* Set adoPrimaryRS = New Recordset
adoPrimaryRS.CursorLocation = adUseClient
SQL = "SELECT * FROM table where ID<>NULL"
adoPrimaryRS.Open SQL, db, adOpenDynamic, adLockBatchOptimistic
Set dgList.DataSource = adoPrimaryRS.Clone
dgList.Refresh
adoPrimaryRS.Close
mbDataChanged = False
End Sub
上面这段程序在别的机器(windowsXP)上没有问题,但在另一台机器(windows98)上*处报错:Run-time error'430':class does not support automation or does not support expected interface.
按你的指点做,问题解决了。但如果打包的话,还要包mdac吗?
这是个被称为“DLL Hell”的问题,据称在ADO.Net里已经解决了