首页 > 解决方案 > System.Data.OracleClient.dll VBA 中出现“System.Data.OracleClient.OracleException”类型的第一次机会异常

问题描述

谁能帮我解决这个问题。我收到此错误

我检查了 System.Data.OracleClient 路径,它是正确的。

Public oradb As String = "Data Source=DB;User ID=login;Password=psw;Unicode=True"
Public cn As New OracleClient.OracleConnection ' Visual Basic


Imports System.IO
Imports System.Data
Imports System.Text
Imports System.Data.OracleClient
Imports System.Data.OracleClient.OracleType

Public Class Form1

    Dim cmd As New OracleClient.OracleCommand

    Dim query, query1 As String
   
    Private Sub RF_Insert()
        Try
            If cn.State <> ConnectionState.Open Then
                cn.Open()
            End If
            For i = 0 To Grid_RF.Rows.Count - 1

                cmd.CommandText = "INSERT into tmp_table (operator_name,real_minutes,insert_date) values('" & Grid_RF.Rows(i).Cells(1).Value.ToString & "', '" & Grid_RF.Rows(i).Cells(2).Value & "','" & nDate & "')"
                cmd.Connection = cn
                cmd.ExecuteReader()
            Next

        Catch ex As Exception
        End Try
    End Sub
    enter code here

标签: vb.netoracle

解决方案


推荐阅读