K
kic
My project:
Uses MSDE * 1, SQL SERVER * 2.
Application server with MSDE.
2 * Data servers with SQL Server.
Users login via ASP.NET, if SQL Server A is busy/unavailabe then connection
is made to SQL Server B.
Application server then connects to local MSDE (instance c).
MSDE C: copies the data required via ?? to MSDE; reports are produced using
Local (Instance C).
Do I need to use MSDE (Instance C)? The Data Servers hold report data only.
There isn't a round trip, there no transactions involved.
Can I build the connection at run time, using the Try Catch? Can I use
unbound Datasets? There by storing the reports in XLM?
Any insights or samples would be appreciated.
James
Uses MSDE * 1, SQL SERVER * 2.
Application server with MSDE.
2 * Data servers with SQL Server.
Users login via ASP.NET, if SQL Server A is busy/unavailabe then connection
is made to SQL Server B.
Application server then connects to local MSDE (instance c).
MSDE C: copies the data required via ?? to MSDE; reports are produced using
Local (Instance C).
Do I need to use MSDE (Instance C)? The Data Servers hold report data only.
There isn't a round trip, there no transactions involved.
Can I build the connection at run time, using the Try Catch? Can I use
unbound Datasets? There by storing the reports in XLM?
Any insights or samples would be appreciated.
James