请教
1:
Set cn = New ADODB.Connection
connstr = "Data Source=OPEN_VIEW;User=cww;Password=jjh5612;Initial Catalog=P
ubs"
cn.Provider = "SQLOLEDB" '设定Privder是SQL Server OLE DB,该名称随不同的
'Database Privder不同而有所不同
cn.ConnectionString = connstr
cn.Open
sql = "Select * from Authors"
Set rs = New ADODB.Recordset
Set rs.ActiveConnection = cn
rs.CursorLocation = adUseServer
rs.Open sql, cn, adOpenKeyset, adLockOptimistic
问:
Data Source=OPEN_VIEW是不是ODBC里设置的数据源,
Initial Catalog=Pubs指的是什么,
2:
Dim connstr As String
Set cn6 = New ADODB.Connection
cn.Provider = "MSDASQL"
connstr = "UID=sa;PWD=sa;Database=cwwpf@eis;" _
+ "Driver={OpenLink Generic 32 Bit Driver};" _
+ "Host=192.168.0.61;" _
+ ";FetchBufferSize=30" _
+ ";NoLoginBox=Yes" _
+ ";Options=" _
+ ";Protocol=TCP/IP" _
+ ";ReadOnly=No" _
+ ";ServerOptions=" _
+ ";ServerType=Informix 7.2"
cn.ConnectionString = connstr
cn.Open
问
Database=cwwpf@eis是什么意思