InfoPath Dev

I'm integrating InfoPath forms with Sharepont. Pulling from and posting to a SPS list is no problem. When using a data connection to an SQL table I receive a Cannot Access information Across Domains" error.  I can't find a solution to this issue anywhere. Both servers are in the same sub domain (healthcare.uiowa.edu). Unfortunately still using InfoPath 2003 and Sharepoint 2003 (healthcare is a slow adopter when they aren't really interested). Anyway, any suggestions would be greatly appreciated.

Cross domains permissions setup with InfoPath can be a real pain to setup.  Many of our customers find our products because they just couldn't get it working in their environment.

We have a generic web service called DBXL that solves the cross domain issue and at the same time makes it easier for you to get your InfoPath data into SQL.

DBXL also makes querying from SharePoint and or SQL easy as well.

You can read more about DBXL here: http://www.qdabra.com/en/products/DBXL.aspx and I would be happy to demo the tool to you if you want to see it in action and understand it works.

Send me a private message if you would like more information or a demo.

Ted

To remove the error go to Internet Explorer > Tools > Internet Options > Security tab > Click Internet zone > Click Custom level... button > in Miscellaneous/Access data sources across domains click Enable.

Hope it woks for you. Please tell us.