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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05