InfoPath 2007 & SQL Server 2005

[Dan]

Hi there, 1st of all I am fairly new to InfoPath and am learning as I go so
please be patient with any 'silly' questions!

I manage a number of SQL Servers across 3 sites and we are in the process of
moving them onto a central server so that they can be managed within one
session of SQL Server.

I began playing with InfoPath 2007 last week and managed to connect it to
the database and run queries.

My question however relates to wheter InfoPath is powerful enough to connect
to more than 1 SQL connection to perform a query over multiple databases.
Please bear in mind that the architecture of all databases over the 3 sites
are identical just with different information contained within the tables.

If this is not possible through a single query would this be possible in
another way??

Any help would be great.
Thanks
Dan

 

[Frederik Van Lierde]

Just a first question.
Did you thought of the idea to let one server query the other
servers ? As this looks logicall as in the future you will bring all
servers together. This way you don't need to change your InfoPath.

So you ad a SP to Server 1 who create a union between Server 1,
Server2 and Server 3.

Is this a possible way to go ?

Frederik Van Lierde
http://blog.SilverSandsAssociates.com

Do you follow us already? http://Twitter.com/SilverSands_IT