VB6怎么连接paradox7的数据库?
zfl2k 2003-04-15 04:29:31 我有一带密码的paradox数据库,用ado连接提示
‘实时错误-2147467259(80004005)
[Microsft] [odbc paradox驱动程序]外部数据库中(10498)的意外错误’
我的paradox版本为4.00.4403.2,
代码如下:
Dim adoRS As New ADODB.Recordset
Dim db As New ADODB.Connection
db.CursorLocation = adUseClient
db.Open "Provider=MSDASQL.1;dsn=Paradox7;uid=;pwd=123;"
adoRS.Open "select * from t1", db, adOpenStatic, adLockReadOnly