Thanks for the input about the messaging from connection... I tracked the errors using aerror() 2nd item, and found the problem. Apparently, SQL is case sensitive on the pass through and didn't associate the column selection of
XDiagID.field with the FROM XDIAGID alias... (so stupid...)


>The modified ODBC driver saved as a separate Data Source Name.
>
>>>
>>>No more verbose message? Try going into the DSN and modifying it to show alert messages and see what you get then.
>>
>>Ok, I'm drawing a blank, what does DSN standfor.... or are you referring to the SQL Connection information