关于如何在Windows应用程序中共享SQL数据库 [英] About How to share SQL Database in windows application

问题描述

Hello Everyone，

我在服务器计算机上安装了一个窗口应用程序。我想通过使用相同的应用程序从其他计算机的服务器访问数据库Plz帮助我。

Hello Everyone,
I have one window application installed on server computer. I want access database from server from other computer by using same application. Plz help me.

推荐答案

我建​​议从这里开始： ADO.NET [ ^ ]

ADO.NET（核心数据访问） [ ^ ]



要在LAN / WAN中的计算机之间共享数据，您需要启用TCP / IP连接 [ ^ ]。有时需要配置Windows防火墙以允许访问MS SQL服务器 [ ^ ]。



接下来，您应该定义正确的连接-string到MS SQL服务器 [ ^ ]。

I would suggest to start here: ADO.NET[^]
ADO.NET (core data access)[^]

To share data between computers in LAN/WAN you need to enable TCP/IP connection[^]. Sometimes it is necessary to configure Windows Firewall to allow access to MS SQL server[^].

Next, you should define proper connection-string to MS SQL server[^].

您还没有真正提供足够的信息让我们能够提供帮助 - 我们不知道应用程序或其数据库的第一件事就是能够说出我们可以做的任何事情肯定会有意义。



最重要的是，如果你告诉我们使用数据库的技术会有所帮助。是MS Access吗？ MS SqlServer？甲骨文？ MySQL的？ MongoDB的？还有别的吗？



它是基于服务器的数据库还是基于文件的数据库？



你说你想要使用相同的应用程序从其他计算机访问数据库。你是说'通过在服务器上使用应用程序作为管道'（可能不是）？你的意思是'通过在另一台计算机上安装应用程序，但引用存储在服务器上的数据'？我首先阅读应用程序的安装指南，特别注意与不同计算机上的应用程序及其数据相关的部分（如果有的话）。

You haven't really provided enough information for us to be able to help - we don't know the first thing about the application or its database to be able to say anything we can be sure will be meaningful.

Most importantly it would help if you told use the technology of the database. Is it MS Access? MS SqlServer? Oracle? MySql? MongoDB? Something else entirely?

Is it a server-based database or is it file-based database?

You say you want to access the database from some other computer by using the same application. Do you mean 'by using the application on the server as a conduit' (probably not)? Do you mean 'by installing the application on the other computer, but referencing the data stored on the server'? I would start by reading the installation guide for the application, paying special attention to the section (if any) that relates to having the application and its data on distinct computers.

让我理解这一点。

您的数据库位于dbserver1中，您的应用程序app1.exe位于appServer1中。现在，您想使用ur app1.exe从appServer2访问数据库。在这种情况下，因为这是Windows应用程序，将您的app1.exe移动到appServer2并从那里运行它。还要检查你是否从appServer2到你的dbServer1没有任何连接问题。

Let me understand this.
Your db is in dbserver1 and your application app1.exe is in appServer1. Now u want to access the db from appServer2 using ur app1.exe. In this case, as this is windows application, move ur app1.exe to appServer2 and run it from there. Also check if u dont have any connectivity problem to your dbServer1 from appServer2.

这篇关于关于如何在Windows应用程序中共享SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！