你用下面的代码试试,这是我以前用过的StrConnect = "ODBC;DSN=" & theDSN & ";UID=" & theUID & ";PWD=" & thePwd & ";Database=" & theDatabaseName & ";"
Set db = DBEngine.Workspaces(0).OpenDatabase(vbNullString, 0, 0, StrConnect)
Set re = db.OpenRecordset("select * from yf order by id")
Set db = DBEngine.Workspaces(0).OpenDatabase(vbNullString, 0, 0, StrConnect)
Set re = db.OpenRecordset("select * from yf order by id")
谢谢,您说的好象是用ADO联接的,aduseclient常数好象只在ADO中定义的recordset才有用。
TO:senble(小哈)
我再试试,估计成功的几率不大,我以前也是这么联ODBC,能用,可这次用的是Sql Anywhere数据库就不成功了。
"DefaultDir=c:\dbpath\;" & _
"Dbf=c:\sqlany50\mydb.db;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;" & _
"Dsn="""