为什么打不开数据库呢
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Provider = "MSDASQL" 'Microsoft OLE DB Provider for ODBC)
'因为是透过ODBC来做,所以connstr的设定,和使用RDO ODBC的连结字串皆相同
connstr = "UID=;PWD=;Database=text;" _
+ "Driver={microsoft access driver (*.mdb)};" _
+ "Host=112.113.246.2;" _
+ ";FetchBufferSize=30" _
+ ";NoLoginBox=Yes" _
+ ";Options=" _
+ ";Protocol=TCP/IP" _
+ ";ReadOnly=No" _
+ ";ServerOptions=" _
+ ";ServerType=Informix 7.2"
cn.ConnectionString = connstr
cn.Open
在cn.open处出现实时错误 -2147217842 (80040e4e)
取消操作怎么回事
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Provider = "MSDASQL" 'Microsoft OLE DB Provider for ODBC)
'因为是透过ODBC来做,所以connstr的设定,和使用RDO ODBC的连结字串皆相同
connstr = "UID=;PWD=;Database=text;" _
+ "Driver={microsoft access driver (*.mdb)};" _
+ "Host=112.113.246.2;" _
+ ";FetchBufferSize=30" _
+ ";NoLoginBox=Yes" _
+ ";Options=" _
+ ";Protocol=TCP/IP" _
+ ";ReadOnly=No" _
+ ";ServerOptions=" _
+ ";ServerType=Informix 7.2"
cn.ConnectionString = connstr
cn.Open
在cn.open处出现实时错误 -2147217842 (80040e4e)
取消操作怎么回事
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货