Windows exe工作不在没有安装sql的系统上工作 [英] Windows exe working not working on systems where there is no sql installed

问题描述

大家好



我有一个Windows应用程序（exe）在某些系统中正常运行但在没有安装sql的Windows服务器系统中无法运行。



我希望在每台用户计算机上安装该exe，但用户不会在系统中安装sql。



任何人都可以指导我有什么我想念的。





谢谢





Suman

Hi all

I have a windows application (exe) which is running fine in some systems but not working in windows server systems where there is no sql installed.

I want that exe to be installed on each users computer but users wont have sql in there system.

Can anyone guide me is there anything i am missing.


Thanks


Suman

推荐答案

如果您使用的是SQL数据库，那么运行代码的PC需要能够联系运行SQL服务器实例的PC - 它几乎肯定不会在本地PC上，因为在开发之外，用户安装SQL服务器非常非常罕见：它是一个复杂的安装，它非常容易出错。



所以：你需要提供一个自定义工具让用户联系正确的SQL实例（具有正确数据库的实例）通过连接字符串在他的网络上，或更改您的软件以使用不需要SQL服务器的数据库。

如果您不期望数据库是多用户，那么我强烈建议后来。 SqLite，SQLCE甚至Access对于单个用户来说要好得多，因为他们不需要太多（如果有的话）额外的安装 - 几个DLL都是。

If you are using SQL database, then the PC running the code needs to to be able to contact the PC running the SQL server instance - it almost certainly won't be on the "local" PC, because outside of development, it is very, very rare for a user to have SQL server installed: it's a complex install which it is very easy to get wrong.

So: either you need to provide a customisation facility to let the user contact the right SQL instance (the one with the right DB attached) on his network via a connection string, or change your software to use a database which doesn't require SQL server.
If you are not expecting the DB to be multiuser, then I would strongly recommend the later. SqLite, SQLCE, or even Access are much better for single user as they don;t require much (if any) additional installation - a couple of DLLs is all.

这篇关于Windows exe工作不在没有安装sql的系统上工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！