Whew!

Glad I could point you in the right direction. :-)


>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