onnectionString="Provider=sqloledb;Data Source=192.168.0.54,1433;Network Library=DBMSSOCN;Initial Catalog=retail;User ID=ovalretail;Password=ovalretail;"adodc连接数据库
With Adodc1
.ConnectionString = ConnectionString & "; Mode=Read"
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.CommandType = adCmdText
.RecordSource = ssql
.Refresh
End With
可还是出错误:mutiple-step OLE DB operation generated error
project 的reference里activex data objects 2.0 libary,如果是这个太低级换成2.1以上的话adodc控件的一些事件编译就过不了了,为什么啊?
With Adodc1
.ConnectionString = ConnectionString & "; Mode=Read"
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.CommandType = adCmdText
.RecordSource = ssql
.Refresh
End With
可还是出错误:mutiple-step OLE DB operation generated error
project 的reference里activex data objects 2.0 libary,如果是这个太低级换成2.1以上的话adodc控件的一些事件编译就过不了了,为什么啊?
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.Open
"Provider=MSDataShape.1;Data Source=192.168.0.54,1433;" & _
"Connect Timeout=15;UID=ovalretail;PWD=ovalretail;Database=DBMSSOCN;Data Provider=SQLOLEDB"
试试
procedure declaration does not match description of event or procedure having the same name.这个怎么解决呀
http://expert.csdn.net/Expert/topic/2710/2710006.xml?temp=8.526248E-02