VB 2008 基于服务的数据库到 SQL Server 2008 [英] VB 2008 Service Based Database to SQL Server 2008

问题描述

我不擅长 Visual Basic 但我有一个项目，我被困住了，需要你的帮助.

我创建了一个数据库项目，我只是从NEW ->基于服务的数据库，现在做了一个项目我必须在我办公室的 SQL Server 上安装这个程序，因为我的项目有一些链接管理面板来添加信息，我希望我的同事看到这个消息，但我没有知道如何将基于服务的数据库切换到 SQL Server.请如果有人可以帮助我.

我还想承认，在 youtube 上我看到通过添加新数据集比 SQL Server 更容易 -> 用户和密码并像这样连接，但新连接数据源中没有列出 SQL Server.

我使用的是 VB 2008 和 SQL Server 2008

解决方案

首先你需要了解什么是基于服务的数据库:

基本上，基于服务的数据库是将数据库存储在服务器上.要访问数据库，您需要运行 SQL Server 服务......因此是基于服务的".您连接到服务器，查询数据库，并取回信息.

所以只要他们的 SQL Server 服务运行这些数据就可以工作，您只需要修改您的连接字符串，实际上如果您使用相同的数据库，连接字符串总是相同的.您唯一需要更改的是值，即数据库名称、用户 ID、密码和源(localhost"或您将连接的任何 IP 地址).

I am not good in Visual Basic But I have a project and I am stuck and need your help.

I created a database project, I simply created from NEW -> Service Based Database and made a project now I have to install this program in my office on SQL Server because my project has something link admin panel to add info and I want my colleagues to see this news, but I don't know how to switch Service Based Database to SQL Server. Please if somebody can help me.

Also I want to admit that on youtube I saw that it's easy to make from Add New Dataset than SQL Server -> User and Password and connect like this but there is no SQL Server listed in the NEW CONNECTION Data Source.

I am using VB 2008 and SQL Server 2008

解决方案

First you need to understand What is Service based database :

Basically, a service-based database is when the database is stored on a server. To access the database, you need to have the SQL Server service running....hence the "service-based". You connect to the server, query the database, and get the information back.

So as long their is SQL Server service running this data will work all you need is just modify your connection string , Actually if you are using same Database, the connection string is always the same. The only thing that you will change is the value, which are the database name, user id, password and the source ("localhost" or any IP Address that you will be connected).

这篇关于VB 2008 基于服务的数据库到 SQL Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！