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