Windows应用程序使用sql server 2008 [英] windows application using sql server 2008

问题描述

我正在制作一个处理sql server 2008的Windows应用程序来处理sql查询.

该应用程序已完成，并且在服务器上安装了sql server，并且数据库已连接到该服务器.
现在，我想知道如何使程序处理服务器上的数据库，换句话说，我想知道必须在服务器上完成的sql server的设置，以允许应用程序访问数据库.

谢谢您.

I''m making a windows application that deals with sql server 2008 to handle sql queries.

The application has been finished, and sql server is installed on a server and the database is attached there.
Now I want to know how to make the program deal with the database on the server, in other words I want to know the settings of the sql server that must be done on the server to allow the application access the database.

Thank you

推荐答案

您声明该应用程序已完成，因此可以假设您已针对SQLServer2008实例对其进行了测试.如果这样的话，AFIAK，它应该可以与服务器上的版本一起使用.所有需要做的就是更改连接字符串以指向服务器实例而不是测试实例.

You state that the application is finished, so presumable you have tested it against an SQLServer2008 instance. If it worked then, AFAIK, it should work against the version on the server. All that should need doing is to alter the connectionstring to point to the server instance instead of your test instance.

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