Remote SQLServer Connection in .NET
-
:) Hi I am in the need to develop a .net component that can communicate two different sql server databases. These two servers are physically different location. That .net application will be in server A and it update some data into Server B located in some other place. Can any one help me to develop database connectivity in either VB.net or C#.NET? :-O M.Sendilkumar TVS Infotech Ltd Chennai
-
:) Hi I am in the need to develop a .net component that can communicate two different sql server databases. These two servers are physically different location. That .net application will be in server A and it update some data into Server B located in some other place. Can any one help me to develop database connectivity in either VB.net or C#.NET? :-O M.Sendilkumar TVS Infotech Ltd Chennai
The SqlConnection object will take a connection string that gives the name of the server. All you need to do is ensure that your .NET component can see both databases. There is nothing different involved from connecting normally.
Do you want to know more? Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
-
The SqlConnection object will take a connection string that gives the name of the server. All you need to do is ensure that your .NET component can see both databases. There is nothing different involved from connecting normally.
Do you want to know more? Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
In my development two servers are in different location that means first one is in New Delhi and second one in singapore, not even in private network like VPN.My problems is how to construct a connect string either for SQLServer provider or OleDB Provider Please find something for me...! M.Sendilkumar TVS Infotech Ltd Chennai
-
In my development two servers are in different location that means first one is in New Delhi and second one in singapore, not even in private network like VPN.My problems is how to construct a connect string either for SQLServer provider or OleDB Provider Please find something for me...! M.Sendilkumar TVS Infotech Ltd Chennai
You need a network connection of some kind between the SQL Server and your .NET application.
Do you want to know more? Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
-
You need a network connection of some kind between the SQL Server and your .NET application.
Do you want to know more? Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
Yes we do have a VPN. M.Sendilkumar TVS Infotech Ltd Chennai