Accessing a database on a local network
I am trying to run a vb 2010 application using sql express 2008. I have the app on the server (ELDSRV1) and an instance og sql 2008 on both the server and my workstation (ELDWK1). I can run the app from the server but it won't find the mdf file when I run it from the workstation (using a shortcut to the exe.)
Any clues?? In the connection string I refer to the Data Source as ELDSRV1\SQLEXPRESS and the database as E:\ELD\DATA\MyFile.mdf. The E designation is the servers drive letter while the workstation refers to the drive as P: could this be the problem??
Any help would be appreciated
Thanks
Brad
Any clues?? In the connection string I refer to the Data Source as ELDSRV1\SQLEXPRESS and the database as E:\ELD\DATA\MyFile.mdf. The E designation is the servers drive letter while the workstation refers to the drive as P: could this be the problem??
Any help would be appreciated
Thanks
Brad
Selected Articles