ODBC Net driver throw an exception

[Tony Do]

Does anyone have problem of running stored procedure from VB .NET using the
ODBC driver, The OleDB driver work OK with the same Stored Procedure, also
the ASP work OK with that same Stored Procedure.

Here is the VB .NET Code

Dim constr as String =
"DSN=UPLUS;UID= db2admin;PWD=of fice;MODE=SHARE ;DBALIAS=UPLUS; PATCH2=6;PATCH1 =
1024;LOBMAXCOLU MNSIZE=1048575; LONGDATACOMPAT= 1;"
Dim OConnection as New System.Data.ODB C.ODBCConnectio n(constr)
Dim OCommand As New System.Data.ODB C.ODBCCommand(" InsertAreturn10 ",
OConnection)
OCommand.Comman dType = CommandType.Sto redProcedure
OConnection.ope n()
OCommand.Execut eNonQuery()
OConnection.clo se()

Produce the error
ERROR [42601] [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token
"END-OF-STATEMENT" was found following "InsertAreturn1 0". Expected tokens
may include: "JOIN <joined_table>" . SQLSTATE=42601
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Odb c.OdbcException : ERROR [42601] [IBM][CLI
Driver][DB2/NT] SQL0104N An unexpected token "END-OF-STATEMENT" was found
following "InsertAreturn1 0". Expected tokens may include: "JOIN
<joined_table>" . SQLSTATE=42601
Where as the following code (OleDB driver) run fine

Dim constr as String ="Provider=IBMD ADB2.1;Password =office;Persist Security
Info=True;User ID=db2admin;Dat a Source=UPLUS"
Dim OConnection as New System.Data.Ole Db.OleDbConnect ion(constr)
Dim OCommand As New System.Data.Ole DB.OleDbCommand ("InsertAreturn 10",
OConnection)
OCommand.Comman dType = CommandType.Sto redProcedure
OConnection.ope n()
OCommand.Execut eNonQuery()
OConnection.clo se()

[stant]

Tony, have you made progress on this issue? I am having the exact same problem with a c# console app, but my stored proc also accepts parameters. I wonder if you are going to begin experiencing a different problem with oledb once you introduce params. Please email me at stan_r_teitelba um@progressive. com to ensure that i get your response.