问题描述
大家好，
我需要将我的Visual Studio LightSwitch与VB.NET项目连接到SQL数据库，该数据库位于本地网络上的共享驱动器上。 。
数据库名称是：Proj2014DB.mdf
包含数据库的PC名称是：PCNO10
驱动器在包含数据库的PCNO10上是驱动器：D：\ MyDatabase \
当试图发布我的项目以便通过网络工作时Visual Studio LightSwitch问我向数据库提供SQL用户连接字符串，以便在发布后能够连接到数据库。
所需的连接字符串格式为：
数据源= PCNO01-PC ;初始目录= Proj2014 ;集成安全性=真;池化=真;连接超时= 30;用户实例=错误
我的问题是什么是正确的连接字符串，以确保网络上的所有电脑都能识别nect到上面提到的数据库（我认为它们标有粗体文字，需要更正）。
提前致谢
Maher
Hi all,
I need to connect my Visual Studio LightSwitch with VB.NET project to SQL database which is located on a shared drive on a local network ..
Database Name is: Proj2014DB.mdf
The PC name containing the DB is: PCNO10
Drive on PCNO10 containing the DB is drive: D:\MyDatabase\
When trying to publish my project to be shared for working over the network Visual Studio LightSwitch asks me to provide the SQL user connection string to the database to be able to connect to the database after publishing.
The required connection string is in the format:
Data Source=PCNO01-PC;Initial Catalog="Proj2014";Integrated Security=True;Pooling=True;Connect Timeout=30;User Instance=False
My question is what is the correct connection string to make sure all pcs on the network will connect to the database mentioned above (I think they are marked with bold text which need to be corrected).
Thanks in advance
Maher
推荐答案
这篇关于如何将LightSwitch连接到共享网络PC驱动器中的SQL数据库。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！