批量插入oracle11g数据OracleBulkCopy 出错,没准你也能遇到。
想飞的狼 2015-11-20 07:32:08 Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim plsc As Oracle.DataAccess.Client.OracleBulkCopy
' plsc = New Oracle.DataAccess.Client.OracleBulkCopy("Data Source=80.81.82.154;Persist Security Info=True;User ID=ccnc;Password=1;", Client.OracleBulkCopyOptions.UseInternalTransaction)
'plsc = New Oracle.DataAccess.Client.OracleBulkCopy("data source=80.81.82.154;initial catalog=g;uid=ccnc;pwd=1")
' plsc = New Oracle.DataAccess.Client.OracleBulkCopy("data source=80.81.82.154;User Id=ccnc;Password=1;Max Pool Size=100;Min Pool Size=5;")
' plsc = New Oracle.DataAccess.Client.OracleBulkCopy("DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=80.81.82.154)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=g)));;User ID=ccnc;Password=1;Persist Security Info=True")
plsc = New Oracle.DataAccess.Client.OracleBulkCopy("data source=80.81.82.154;SERVICE_NAME=g;User ID=ccnc;Password=1")
plsc.DestinationTableName = "XXX"
plsc.WriteToServer(t1)
MessageBox.Show("OK")
End Sub
出这个错误“Oracle.DataAccess.Client.OracleBulkCopy”的类型初始值设定项引发异常。
想把TABLE表T1放到ORACLE的XXX表,服务器是64位的,我开发环境是32位系统和32位ORACLE客户端+vb2005,引用的32位ORACLE.DATAACCESS,求解