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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Herfried K. Wagner [MVP]]

* Ivan Weiss <iv*****@optonline.net> scripsit:

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:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[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

"Ivan Weiss" <iv*****@optonline.net> wrote in message
news:uy**************@TK2MSFTNGP09.phx.gbl...

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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 wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[One Handed Man]

COOL, At least u fixed it !

OHM
Ivan Weiss wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!