InfoPath Dev

I have a SQL db data connection for the drop-down field on the form. It works fine in a preview, but gives the "A call to XDocument.GetDOM failed..." error on the server.
The connection has been converted to the file and includes login credentials. The SQL database is NOT on a SharePoint server. Please, advise.

Thank you!

For browser forms, it won't work because they don't forward credentials. You'll need to use a Web service such as Qdabra's DBXL Web service.

For filler forms, it should work so long as the user has connection to the databse.

Please clarify whether you are using browser or filler.

Thanks!

I'm using a filler form. I just noticed that I can open some of the existing documents, but not all of them. Opening of the empty form fails all the time.

Thanks!

I have no idea. This is very strange.

 It sounds like there is either content in one of your views or rules that is referencing a data source that has been deleted. Did you have a data source called 'xxx' that you removed? I would suggest checking the Rule Inspector for errors, and if that doesn't work, exporting the form's source files and searching for the name of that data source to see if you can find something that points you in the right direction.

Resolved. Since you told me I shouldn't have any problems with client-side form, I just suspected a piece of wrong formula somewhere and blindly re-did the whole form (from a latest saved template). This time it sees like I succesfully avoided an error and everything works.

Thank you,  Jimmy and Patrick!