>*create sql view testodbc2 connection HazMat;
>* as select id,carrier from carriers

you may want to include the keyword SHARE in the CREATE command to use a shared connection shared if one is available and if one is needed.