Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Sql Across a network

Author  Topic 

BradH
Starting Member

6 Posts

Posted - 2011-05-05 : 04:12:28
I am new to SQL and am having problems accessing a database (mdf) I have copied to my network drive so others on the network can access it. I have an instance of SQL loaded on Workstation 1 and an instance loaded on the Network server( E-SRV1). I have changed the Connection string from:
Data Source= _
.\SQLEXPRESS;AttachDbfFilename=C:\Data\Folders\MyFile.mdf;
to:
Data Source= _
E-SRV\SQLEXPRESS;AttachDbFilename=E:\DATA\Folders\MyFile.mdf;
but the application (vb express 2010 ) cannot find the file.
I can access the file from SSMS but not from within the program
Any halp would be appreciated
Brad
   

- Advertisement -