Infopath - changing sql servers

Posted by ScottStonehouse on Stack Overflow See other posts from Stack Overflow or by ScottStonehouse
Published on 2010-02-24T22:55:19Z Indexed on 2010/03/22 14:01 UTC
Read the original article Hit count: 453

Filed under:

infopath

|

sql-server

I have an InfoPath form which has sort of a master-detail pattern, with two tables in the underlying main datasource. I am trying to migrate this to a new SQL Server - same database, just moved from a SQL2005 machine to a SQL2008 machine.

If I change the servername, it also wants me to change the database and tables. If I select the same database and master table, the bindings are maintains for the master table. But there doesn't appear to be a way to select multiple tables when you change the datasource, so you lose the detail bindings.

Am I missing something - I'm pretty new to InfoPath.

© Stack Overflow or respective owner

Related posts about infopath

INFOPATH 2007 Copy XPATH Option, How i can get the Copy Xpath option in INFOPATH 2003

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi friends, I new for this Inopath, My quesion, InfoPath 2007 , I Can right click filed name i can get CopyXPATH, I Want CopyXPath function in INFOPATH 2003, HOW I Can get CopyXpath option Thanks >>> More
Saving a modified InfoPath form to its form library

as seen on Server Fault - Search for 'Server Fault'
Within our corporate SharePoint 2007 site, there is a particular form library that contains 10 separate files. 9 of these are either Excel, Word, or PowerPoint files and one of these is an InfoPath 2007 form that serves as a report. After noticing an error within this InfoPath form, I saved this… >>> More
Load InfoPath 2010 Forms & XSN Templates in .NET Web Applications

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Aspose.Form for .NET now provides full support for InfoPath 2010 controls. Now it is possible to load InfoPath 2010 forms and XSN Templates in .NET Web Applications. Following is the list of InfoPath 2010 controls that are fully supported. Text Box … >>> More
Populate InfoPath Combo Box

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to populate a drop down and found this page, which provides part of the solution: http://www.bizsupportonline.net/infopath2007/programmatically-fill-populate-drop-down-list-box-infopath-2007.htm I got this to work, but if players.xml was changed, the drop down list didn't reflect it… >>> More
Creating a new Active Directory account with an InfoPath form

as seen on Server Fault - Search for 'Server Fault'
I am setting up a business partner portal in our Sharepoint server. There will be an AD group with permissions limited to viewing and possibly contributing to the specific business partner site and employees of our business partners will have accounts created for them as needed. Now we would like… >>> More

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More