Windows应用程序中需要sql server [英] need of sql server in Windows Application

问题描述

HI，
我创建了一个Windows应用程序，该应用程序需要与远程计算机中存在的sql server实例连接，该应用程序是在.net framework 4.0下构建的.所以我的问题是，应在安装我的应用程序的计算机中安装sql服务器还是sql服务器客户端.该计算机已经安装了Framework 4.0.

预先感谢，
gaurav

I have created a windows application which needs to connect with sql server instance which is present in remote machine,the application is built under .net framework 4.0. So my question is whether sql server or sql server clientshould be installed in the machine where my application is installed.The machine is already having framework 4.0 installed.

Thanks in advance,
gaurav

推荐答案

不一定要.
Sql Server实例可以在任何地方，但是可以通过有效IP在LAN/WAN中访问，应用程序需要在其连接字符串中使用有效IP和开放端口(例如1433).

请查看以下内容:
SQL Server 2008的连接字符串
通过C#访问SQL Server的入门指南
将Winform连接到远程SQL的最佳方法是什么SERVER?

Necessarily not.
The Sql Server instance, could be every where, but accessible in LAN/WAN by a valid IP, the application needs the valid IP and an open port (for example 1433) in its connection string.

Please look at these:
Connection strings for SQL Server 2008
Beginners guide to accessing SQL Server through C#
What''s the best way to connect Winform to a remote SQL SERVER?

您根本不需要安装SQL Client.

您只需要安装.NET Framework 4.0和您的应用程序即可.如果您在应用中使用第三方控件，则还需要安装任何其他依赖关系.

You don''t need to install the SQL Client at all.

All you need to install is the .NET Framework 4.0 and your application. Any other contorl dependancies when also need to be installed if you''re using 3rd party controls in your app.

这篇关于Windows应用程序中需要sql server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！