Thanks for the reply .. I did as you said but struck another problem. The SQL references a view and the XPath referenced the same view.
However, that continually threw up a Null exception ...
the xpath from InfoPath for the field is
/dfs:myFields/dfs:dataFields/d:vwPersonInfo/@MyOid
however, after a bit of hair pulling we ...