如果要如此,用DSN应该可以!
[DSN]文件
[ODBC]
DRIVER=Adaptive Server Anywhere 6.0
server=172.168.1.166
UID=dba
pwd=sql
Integrated=NO
DatabaseName=asademo
[DSN]文件
[ODBC]
DRIVER=Adaptive Server Anywhere 6.0
server=172.168.1.166
UID=dba
pwd=sql
Integrated=NO
DatabaseName=asademo
";database=" & strDBName & ";UID=" & strUID & ";PWD=" & strPassWord '& ";DistribTx=1"把Provider改成Accsess的提供者就OK