Hi I am trying to execute a stored procedure and read the output values. I am getting a conversion error but I cannot figure out where its coming from. Here is the error:

Exception Details: System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type nvarchar to int.

Source Error:


Line 39: conn.open()
Line 40:
Line 41: comm.ExecuteNonQuery()
Line 42:
Line 43: conn.close()

Here is the full source:

Dim comm as New ODBCCommand("{call jgrant_awcconnect..edit_equipment (?, ?, ?, ?, ?, ?)}", conn)
comm.parameters.add("@equipmentId", System.Data.SqlDbType.bigint)
comm.parameters("@equipmentId").Direction = ParameterDirection.Input
comm.parameters("@equipmentId").value = CInt(session("EquipmentId"))
comm.parameters.add("@Short", System.Data.SqlDbType.Nvarchar)
comm.parameters("@Short").Direction = ParameterDirection.Output
comm.parameters.add("@Long", System.Data.SqlDbType.Nvarchar)
comm.parameters("@Long").Direction = ParameterDirection.Output
comm.parameters.add("@Owned", System.Data.SqlDbType.Nvarchar)
comm.parameters("@Owned").Direction = ParameterDirection.Output
comm.parameters.add("@Job_Price", System.Data.SqlDbType.money)
comm.parameters("@Job_Price").Direction = ParameterDirection.Output
comm.parameters.add("@Job_Cost", System.Data.SqlDbType.money)
comm.parameters("@Job_Cost").Direction = ParameterDirection.Output
conn.open()

comm.ExecuteNonQuery()

conn.close()
txtShort.text = comm.parameters("@short").value

This looks like a SQL syntax problem. This kind of error usually happens when you are have a type mismatch in SQL commands. It could be a conflict between two columns or a parameter and column. Please post the error message and the stored procedure code in the one the SQL Language or the appropriate SQL Server forum.

-Peter

yeah this is what I thought at first as well but I called the code within sql query analyzer and everything worked out. What I am wondering is whether I my call and parameter statements are correct. That is all I can think of that might be wrong.