Dear Fellows,
I want to make an online transaction program for which I need help. The problem is that, if a branch enters an entry that entry should hit three system’s databases. These three systems are connected to network but the application is not connected. For example, there is two branches namely branch1 and branch2 and a head office namely HO1. If a user at branch1 enters a record that record not only hit that branch database, but also hit branch2 and HO1 databases as well. Can I use Virtual Private Network (VPN) to do this?
Is there any tutorial available for such problem? I am using VB.NET and SQL Server 2000. Any suggestion will highly be appreciated.
Niradhip ChakrabortyPosted May 8, 2009, 1:52 AM
Specify the IP Address of the SQL Server database in the Data Source
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword
If all the branches are in same network then you can have one single database
moreover SQL Server accepts the remote connections.
So its better to have a single database in network which will connect with all the office.
Imran ShahPosted May 8, 2009, 12:12 AM