Learn how you can peer-enable business applications by allowing them to share state in a serverless peer network.
Kevin Hoffman
MSDN Magazine July 2008
View Complete Post
Lyn Robison
MSDN Magazine December 2003
simple question:
ÃÂ
IÃÂ have create a web site in visual studio with form user authentication.ÃÂ Thats create a mdf database in this path:
c:\inetpub\wwwroot\website\app_data\aspnetdb.mdf
thats use Sql server
i would like to access this database with c# form application on a network with multi-user.
if i changeÃÂ the drive letter of theÃÂ pathÃÂ above to f:\ (mapped drive)ÃÂ or \\server\c\, i got this message
System.Data.SqlClient.SqlException: The file "h:\Inetpub\wwwroot\website\App_Data\ASPNETDB.MDF" is on a network path that is not supported for database files.An attempt to attach an auto-named database for file h:\Inetpub\wwwroot\website\App_Data\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
i read that
In SQL 2008 R2, I understand that Peer-to-Peer replication can provide a unique opportunity.
I'm currently looking to understand if this capability feeds into an application architecture I'm beginning to research a concept for.
My firm is a medical device manufacturer. We are looking to build a new medical device gateway. This gateway is pretty simple in that medical devices connect to the gateway to transfer device operation information (little (1000 character) XML formatted messages, several hundred messages per minute).
In our legacy design, we have N+1 application servers, load balanced, that the medical devices communicate to. These gateway application servers send and receive XML messages to the device, and persist the messages into an Oracle 10g database (boo hiss!)
The current architecture is redundant at the application server level with load balancing, but the DB is the single point of failure.
In drawing up a concept of a new gateway, I was thinking of a design where each node of the application gateway consisted of the application services for device communications as well as MS SQL 2008 R2 Std configured as peer to peer replication between each node (two, three, or maybe four nodes max).
So my thought was to use load balancing to have a device connect to a node in my new gateway, transmit the XML statu
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend