Re: execute problem when upgraded to 4.1

[JeffM JeffM]

I don't know if my problem is related, but I also been receiving exception errors
when calling ExecuteScalar():

OdbcConnection myConnection = new OdbcConnection();
myConnection = new OdbcConnection( myConnString );
myConnection.Open();

OdbcCommand cmd = new OdbcCommand( "SELECT COUNT(*) FROM " + TableName + " " + "WHERE ID=?", myConnection );
cmd.Parameters.Add( "?", OdbcType.VarChar, 40, "ID" ).Value = txtid;

// EXCEPTION ERROR HAPPENS HERE
int total_records = (int)cmd.ExecuteScalar();
myConnection.Close();

This did not ever happen before.