Hello,
I'm having problem calling stored procedures from Visual FoxPro database. I got the following exception error:
"System.Data.OleDb.OleDbException: Unrecognized command verb"
Here is my code snipet:
Dim oConn As OleDbConnection = New OleDbConnection(AppSettings("connectionString")
Dim oCmd As OleDbCommand = New OleDbCommand()
oCmd.Connection = oConn
oCmd.CommandText = "generateID" 'calling stored procedure
oCmd.CommandType = CommandType.StoredProcedure
Try
oCmd.Connection.Open()
Dim oDR As OleDbDataReader
oDR = oCmd.ExecuteQuery()
oDR.Close()
.........
Any help would be appreciated. Thanks in advance.
I'm having problem calling stored procedures from Visual FoxPro database. I got the following exception error:
"System.Data.OleDb.OleDbException: Unrecognized command verb"
Here is my code snipet:
Dim oConn As OleDbConnection = New OleDbConnection(AppSettings("connectionString")
Dim oCmd As OleDbCommand = New OleDbCommand()
oCmd.Connection = oConn
oCmd.CommandText = "generateID" 'calling stored procedure
oCmd.CommandType = CommandType.StoredProcedure
Try
oCmd.Connection.Open()
Dim oDR As OleDbDataReader
oDR = oCmd.ExecuteQuery()
oDR.Close()
.........
Any help would be appreciated. Thanks in advance.