Data Connections

[Martin Hofmann]

Hi all

I habe an InfoPath Form with about 6 Data Connections to SQL Server.
Now i want to change the area (New Domain) for this Form. The SQL Server
which saves the Data is another SQL Server with a new name in the new domain.

Now when i open the InfoPath Form in the new area, i have to change all Data
Connections. How do i connect the data, so that i only have to publish the
form in the new area and the Data Connections are ready to the new SQL Server?

Thanx
Martin

 

[kfrost]

Hello Martin,

If I understand you correctly, pretty much what you are saying is that your
database is on a new SQL server and you need all of your connections to
connect to this new server. I would think you would need to open your form
in design mode. Open the Data Connection wizard and select each data
connection and select Modify. Then choose the "change Database" option to
setup a new datasource.

Once you change all of the connections, then republish the form.
Additionally you mention the new domain. I'm assumming there are the
appropriate trust in place to which your account can access the SQL server in
the new domain. If not, you would probably either need to add that trust.
Or make sure you are logging on to your workstation with credentials that
have the appropriate credentials for that SQL server. Or you can use SQL
authentication instead of Windows Authentication.

I'm not sure that exactly covers what you were asking but i hope it helps.

 

[Martin Hofmann]

Hi kfrost

Thanks for your help.
You confirmed me. I hoped it would give a simpler way to change the data
connections. I develop InfoPath Forms for our customer. And with each change
which I make, I have to go to the customer and change the data connections.

 

[kfrost]

Hello Martin,

I wouldn't take what I say as gospel, I'm just started learning my way
around SQL myself. Plus I'm going find my self in your situation as well
with what I plan to do with Infopath.

To my knowlegde all this info is stored in files so you can probably write a
code snippet to automate this. I went digging through the manifest.xsf file
and saw my data connection info.

You could probably just write xml code to open this file and change the
settings. But then you would have to automate re-publishing it. I would
think there is a better way to automate this if you are doing it on a
frequent basis but I have really no good advice to offer at this point.