How do I change the hostname in InfoPath Form data connection?

Dre
  • How do I change the hostname in InfoPath Form data connection? Dre

    I've created a InfoPath form which uses Data Connections. This was on server1.

    Now I want to change this InfoPath Form on server2 (server1 does not exist anymore). I want to add a new Data Connection.

    I do use the Connection Options as Local Connection library, so the link to the data connection file is relative.

    When I look into the Data Connections for the form template, I still see the Connection Source beeing the server1. When I add a new connection, the Source is server2.

    When I Preview the Form, the Form still tries to connect server1 !

    How can I change this ?

    I found a way to do this: Manually editing data connection details in InfoPath 2007 forms. For me, only the save as source files worked.

    Is this the best way to do ?

  • Yes as far I'm aware that's the only way.

    You need to save the source files out in InfoPath client, edit the manifest file with the correct URLs, then save and publish back into SharePoint.

    I haven't come across any community tools that make this process easier but you would think there's a good need for them. You may want to search around for that.

  • It's been a few projects since I've done Infopath, but are we talking about connections stored externally to the form? These are stored in a .udcx file in a Data Connection Library. If so, why isn't it as simple as just editing the .udcx file? If not, why store embed the connection in the form rather than use .udcx files?

    Or am I missing something altogether?

Related questions and answers
  • I need to change the tooltips in an infopath form using the code behind. How should I do that?

  • around Sharepoint Designer 2007, but I can't figure out how to email an InfoPath form with the event details and an 'apprve/reject' button. Grateful for any advice. Thanks! ...sorry if this is a noob question, but I have to start somewhere! I'm working with Sharepoint 2007. I have a custom content type, Room Booking Event. When one is created, I want to start a workflow where the following happens: Using email, I want to send the details of the room booking (fields in the list), to an approver Ideally, I want the approver to be able to approve the booking right

  • within the SharePoint front end. All of the web parts will need to automatically detect consumers and providers to create connections at runtime. What we are looking to do is have webparts discover and automatically connect to other compatible webparts. When a user adds the two compatible parts to a page, the parts should be able create the appropriate connections. We have a well defined interface for passing data between the parts, so the only issue is how to manage the connections. To be clear, we do not want user's to worry about having to create connections themselves. For our

  • I have an InfoPath form that starts a workflow (on item created). The business requirement is that after submission form must be read-only (no changes to the initial request can be made). However workflow must change certain properties of the form (e.g. approval time, approval phase etc.). By default SharePoint workflows run under initiator account, however I am wondering would you recommend creating an event handler that is going to kick start a workflow under system account. Workflow would than be able to revoke all the contribute privileges but still be able to update the form during

  • I have an existing InfoPath 2007 form containing managed code. The form is now published on SharePoint 2007. The form will be edited and created using the InfoPath 2007 client, so no Web Form in this case. I plan to migrate to SharePoint 2010. Since InfoPath 2007 is used as client and I do not want to bother the end user with upgrading, I still want to use InfoPath 2007 as client (No client upgrade to InfoPath 2010, yet) Is it compatible ? Does it work without modifications? What should I change?

  • ; The connection string we are using is "Data Source=xxxx; Initial catalog=yyy; Integrated security=true;" We have tried with a small change in conneciontion string as well "Data Source=xxxx; Initial catalog... impersonate="true" username=”domain\someuser” password=”***” /> If we add “NTAuthority\Anonymous Logon” as a user in custom DB server instance. If we use Sql Authentication “Data Source=xxxx...We have an issue in accessing custom a DB from a SharePoint custom webpart. When we try to access the custom DB from SharePoint webpart we are getting the error "Login Failed for User NTAuthority

  • From SharePoint Designer it is possible to modify the edit and display list forms. From the ribbon in ListSettings tab select Design Forms In InfoPath and choose the content type you want to modify forms for. InfoPath will open with a generated form and the form can be modified. My question is when you publish the form from InfoPath to a SharePoint List is it posible to export the list and import it to list in SharePoint Foundation or are the forms dependent on InfoPath ?

  • in the webpage because I turned off the toolbar that has view selection. But, that means that the engineering team can't see the Team View when they go to the form library. My idea is to have.... Is this the easiest way to do this or should I approach the problem another way? Thanks for any advice you can provide. ...I'm using an InfoPath form embedded in a webpart in a MOSS 2007 webpage. I'd like to have a Customer go to this page and see a certain view and not any of the others. After the form is submitted

  • I am working on replacing our protocol handler with a Connection Framework component, so that SharePoint will crawl our data source. I think I understand the big picture, but I'm missing a lot of the details. I've read the documentation starting at http://msdn.microsoft.com/en-us/library/ee556429%28office.14%29.aspx. I currently have a working BDC assembly; I know it works because I can make... "Data Sources"? Can I use my BDC assembly for this, or do I have to create another assembly?

Data information