如何制作一个在sqlserver和sql上运行的软件 [英] how to make a software which run on sqlserver and sql express both

问题描述

我使用sqlserver数据库创建一个项目。但是我想在sqlexpress数据库中运行它的.exe文件。

比它不起作用。

I make a project with sqlserver data base.but I want to run its .exe file in sqlexpress data base.
than it does not work.

推荐答案

您唯一需要做的就是更改您的应用程序用来指向正确的服务器和实例的连接字符串。但是，您更改的内容以及取决于您的SQL Server和SQL Express安装的内容。

The only thing you have to do is change the connection string your app is using to point to the correct server and instance. But, what you change and to what values depends entirely on your SQL Server and SQL Express installations.

除非您超出 SQL Server Express的限制 [ ^ ]（而且它们非常宽，所以不太可能）那么你应该努力改变的是teh连接字符串 - 检查两者是否配置为smae方式，并使用相同的参数通过SSMS进行试验连接。

Unless you are exceeding the limits of SQL Server Express[^] (and they are pretty wide, so it's not likely) then all you should havce to schange is teh connection string - check that the two are configured the smae way, and do a trial connection via SSMS to both using the same parameters.

这篇关于如何制作一个在sqlserver和sql上运行的软件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！