Design Issue
-
Hello all, I'm new to the .NET universe and there for a little lost in the water. I have a small task to complete and I found myself blocked and pressed for time so decided to ask for help. Any help will be greatly appreciated. Here is my problem... as clearly explained as I can: I have two MSSQL database servers set up that ensure redundancy and back for a data base used by several applications. I also have a service set up that periodically checks to see witch server is up and sets an internal value according to the result of it's tests. My task is to make all the applications interrogate this service to obtain the address of the current SQL server to use. Applications are written in VB, C++ C# and are on variouse machines. Anybody has any idea what would be the best way to do this ? Thank you in advance.
-
Hello all, I'm new to the .NET universe and there for a little lost in the water. I have a small task to complete and I found myself blocked and pressed for time so decided to ask for help. Any help will be greatly appreciated. Here is my problem... as clearly explained as I can: I have two MSSQL database servers set up that ensure redundancy and back for a data base used by several applications. I also have a service set up that periodically checks to see witch server is up and sets an internal value according to the result of it's tests. My task is to make all the applications interrogate this service to obtain the address of the current SQL server to use. Applications are written in VB, C++ C# and are on variouse machines. Anybody has any idea what would be the best way to do this ? Thank you in advance.
The answer that springs immediately to mind here is to use remoting for this. I would have a remotable object in the service which would provide the information you need. Then, your clients would simply use remoting to get this information from the service.
Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.