错误[42000] [Oracle] [ODBC]语法错误或访问冲突 [英] ERROR [42000] [Oracle][ODBC]Syntax error or access violation

问题描述

Imports System.Data
Imports System.Data.Odbc
Partial Class _STUDENTTABLE
    Inherits System.Web.UI.Page
    Dim CON As OdbcConnection
    Dim comm As OdbcCommand
    Dim instance As OdbcDataAdapter
    Dim a As Integer
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub BTNINSERT_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNINSERT.Click
        CON = New OdbcConnection("DSN=DBLOG;Driver=(Oracle in XE);UID=system;PWD=SYS;SERVER=localhost;")
        CON.Open()
        MsgBox("successfully opened")
        comm = New OdbcCommand("INSERTSTUDENT", CON)
        comm.CommandType = CommandType.StoredProcedure
        comm.Parameters.AddWithValue("ID_", TXTID.Text)
        comm.Parameters.AddWithValue("STUDENTNAME_", TXTNAME.Text)
        comm.Parameters.AddWithValue("DEPARTMENT_", TXTDEPART.Text)
        comm.Parameters.AddWithValue("YEAR_", TXTYEAR.Text)
        comm = New OdbcCommand("{call INSERTSTUDENT(_,_,_,_}", CON)
        a = comm.ExecuteNonQuery()
        If a > 0 Then
            MsgBox("success")
        Else
            MsgBox("fail")
        End If
        CON.Close()
        MsgBox("successfully closed")
    End Sub

推荐答案

这应该可以帮助您找到原因并可能找到解决方案 - Google搜索 - ERROR [42000] [Oracle ] [ODBC]语法错误或访问冲突 [ ^ ]

This should help you find the cause and probably a solution - Google search - ERROR [42000] [Oracle][ODBC]Syntax error or access violation[^]

这篇关于错误[42000] [Oracle] [ODBC]语法错误或访问冲突的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！