各位大虾进来看一下?????
我现在是通过ADODC生成的连接串进行数据关联的:
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim commandtextstr As String
Dim cnstring As String
commandtextstr = "select * from 用户信息"
cnstring = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa1;password=1;Initial Catalog=a0001;Data Source=serverjy"
cn.Open cnstring
rs.CursorLocation = adUseClient
rs.Open commandtextstr, cn, adOpenDynamic, adLockBatchOptimistic
我想用ODBC的数据源(DSN)进行数据库关联,该如何修改上面的代码????不知还需不需要做些啥????
假如数据源在:D:\csopen.dsn
uid=sa1
pwd=1