Error when trying to use ODBC Named Parameter with SAP IQ/Sybase IQ DB

Question

I have the following command that works on mySQL but not working with SAP IQ/Sybase IQ DB:

string sql = "select * from someTable where fieldName=@name";
command.CommandText = sql;
command.Parameters.Add(new OdbcParameter()
{
    DbType = System.Data.DbType.Int32,
    Value = 1,
    ParameterName = "@name",
    Direction = System.Data.ParameterDirection.Input
});

command.ExecuteNonQuery();

the error is:

ERROR [42S22] [Sybase][ODBC Driver][Sybase IQ]Column '@name' not found

I suspect that named parameters aren't working with Sybase IQ.

Answer 1

The solution is to count on the order of the parameters and use question maek instead of the named parameter:

string sql = "select * from someTable where fieldName=?";