开发者

How to connect my APP to SQL Server?

开发者 https://www.devze.com 2022-12-24 15:57 出处:网络
I have 1 PC (Windows Server 2003 + SQL Server 2008) and 2 PCs (MS SP2 + my APP) how I can let my APP connects to sql server 2008 on other PC My APP will connect to server to store data in SQL Server

I have 1 PC (Windows Server 2003 + SQL Server 2008)

and 2 PCs (MS SP2 + my APP)

how I can let my APP connects to sql server 2008 on other PC My APP will connect to server to store data in SQL Server 2008 and re开发者_StackOverflow社区ad/delete/edit (basic operations)

what is the best way to do that?

NOTE: my APP is written in C# (.NET Platform)


Look here:

how to connect to another sql server database(server pc) in local area network

How to connect to SQL server through IP

From Connection strings for SQL Server 2008 you have:

Connect via an IP address

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;InitialCatalog=myDataBase;User ID=myUsername;Password=myPassword;

DBMSSOCN=TCP/IP. This is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号