Command.Execute Error (ADO.NET)

  • Thread starter Thread starter Ivan Weiss
  • Start date Start date
I

Ivan Weiss

I am getting the following error from my error handling code:

5 - Expected query name after EXECUTE..

from the following code:

Public Sub insert(ByVal argSql As String)
Dim myConnection As New OleDbConnection(dbConnString)
Dim myCommand As New OleDbCommand()

myCommand.Connection = myConnection
myCommand.CommandType = CommandType.StoredProcedure
myCommand.CommandText = argSql

Try
myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
Catch
DisplayErrorMessage("clsDatabase:insertData")
End Try

End Sub

Any ideas??

-Ivan
 
I can think of a couple of things right off that could cause that error.

1) Is the stored procedure attempting to return data?
2) The stored procedure is incorrect in that it is returning this error.

Hope these help, it is difficult to help without more information, i.e. the
text of the stored procedure and the value of argSQL.

David
 
* Ivan Weiss said:
I am getting the following error from my error handling code:

5 - Expected query name after EXECUTE..

from the following code:

Public Sub insert(ByVal argSql As String)
Dim myConnection As New OleDbConnection(dbConnString)
Dim myCommand As New OleDbCommand()

myCommand.Connection = myConnection
myCommand.CommandType = CommandType.StoredProcedure
myCommand.CommandText = argSql

Try
myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
Catch
DisplayErrorMessage("clsDatabase:insertData")
End Try

End Sub

Any ideas??
Click to expand...

Group for ADO.NET questions:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>
 
It sounds like your sql string is invalid and that either the stored
procedure does not exist or has not been specified.

OHM
 
Sorry guys it was a dumb mistake. I had the command object set to
stored procedure when I was generated the sql statement so it should
have been text.

Thanks

-Ivan
 
Back
Top