Data Connections

Re: Unable to connect to sql server after publish IP 2007

Aruna Akella — Fri, 09 Jul 2010 13:54:52 GMT

Here is another post about cross domain issues.

Hope that helps!

Re: Unable to connect to sql server after publish IP 2007

Aruna Akella — Fri, 09 Jul 2010 13:39:01 GMT

Go through this MSDN article.

Re: Unable to connect to sql server after publish IP 2007

dlgross — Fri, 09 Jul 2010 09:53:27 GMT

Thanks for the suggestion, how to i change the connection to UDC?

Re: Unable to connect to sql server after publish IP 2007

Aruna Akella — Fri, 09 Jul 2010 04:01:53 GMT

It might be cross domain issue. The InfoPath form is trying to retrieve dats that is hosted in a different domain. Can you give your form full trust and try again? or try changing the data connection to Universal Data connection format...

Hope that helps!

Unable to connect to sql server after publish IP 2007

dlgross — Fri, 09 Jul 2010 01:18:11 GMT

I created a secondary connection to a sql server db using sql authentication that works fine on my pc, when i published the form to SP 2007, i get "failed to connect to data source' with the following details:

The query cannot be run for the following DataObject: Comet Units
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.

what did i do wrong, any suggestions would be greatly appreciated.

TIA
Dean