Command.Execute Error (ADO.NET)

[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

 

[David Williams]

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

 

[Herfried K. Wagner [MVP]]

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??

Group for ADO.NET questions:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>

 

[One Handed Man]

It sounds like your sql string is invalid and that either the stored
procedure does not exist or has not been specified.

OHM

 

[Ivan Weiss]

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

 

[One Handed Man]

COOL, At least u fixed it !

OHM