問題描述
我不擅長 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的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！