80% of the time we will install MSDE to run our app, however the other 20% will have SQL Server already installed. 

Would installing a new instance be an option. ...

Thankyou for the repley.  No joy with the SET FMTONLY OFF.  I get the following error returned.

An error occurred while preparing a query for execution against OLE DB provider...