A连接串:"Driver={Oracle in OraHome92};Server=;Uid=;Pwd=;"
B连接串:"Provider='OraOLEDB.Oracle';User ID=' ';Data Source='';Password='';"
用A串连接数据库INSERT数据(有BLOB字段)会报错“sequence err”
用B串连接数据库INSERT数据没问题正常提交
用A的驱动为什么出错?哪位碰到这种情况的,帮忙给点意见。
还有用A的驱动怎么能正常插入数据?
B连接串:"Provider='OraOLEDB.Oracle';User ID=' ';Data Source='';Password='';"
用A串连接数据库INSERT数据(有BLOB字段)会报错“sequence err”
用B串连接数据库INSERT数据没问题正常提交
用A的驱动为什么出错?哪位碰到这种情况的,帮忙给点意见。
还有用A的驱动怎么能正常插入数据?
Dim curConnection As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sds As String
Dim strconn As String
sds = Chr(34) & "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=59.68.224.13)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=JWGL)))" & Chr(34)
strconn = "Provider=MSDAORA.1;Password=zfsoft_gxedu;User ID=gxjxgl;Data Source=" & sds & ";Persist Security Info=True"
Set curConnection = New ADODB.Connection
Set rs = New ADODB.Recordset
curConnection.Open strconnrs.Open "select count(*) from tabs", curConnection, adOpenStatic, adLockReadOnly
MsgBox rs.Fields(0).Value
rs.Close
curConnection.Close
cn.CursorLocation = adUseClient
cn.Open