How to connect remote system

Posted Date: 26 Jun 2009 Posted By: R.Jaya kumar (JK) Member Level: Diamond Points: 1 Responses: 3

hi

How to connectivity Remote Database one machine to another server how will do this pl send full source code

thanks
kumar

Thanks and Regards
Jayakumar

Do not forget to Rate the post...

Responses

Author: Anil Kumar Pandey 26 Jun 2009 Member Level: Diamond Rating: Points: 2

hi,

simply change the connection string.. with the full server name , username and the password..

like


<connectionStrings>
    <add name="Abc" connectionString="Data Source=sql007.abc.com;Initial Catalog=Db_abc;User Id=abc_usr;Password=abc123;" providerName="System.Data.SqlClient"/>-->

</connectionStrings>

Thanks & Regards
Anil Kumar Pandey

Author: D.Jeya kumar(JK) 26 Jun 2009 Member Level: Diamond Rating: Points: 2

Hi,

Add the server name in the web config where Data Source=Servername and check the remote access to the sql server is allowed or not

Regards
JK

Author: R.Jaya kumar (JK) 26 Jun 2009 Member Level: Diamond Rating: Points: 2

hi

thanks to all

thanks
kumar

Thanks and Regards
Jayakumar

Do not forget to Rate the post...

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Image insert
	Previous : Access database
	Return to Discussion Forum
	Post New Message
	Category: Visual Studio

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use