>>selectCmd = "select distinct DO.OptionID, DD.Option_Desc from DealerOpts DO INNER JOIN DealerOptions DD on DO.OptionID = DD.OptionID"
>
>DO is a reserved word.
Good point, may be this was the reason for the failure.
If it's not broken, fix it until it is.
My Blog