Connection String to remote Server not working
Posted on 2016-10-09
I have a c# application that needs to modify a value in a .CSV file. Whilst developing the application I have used a local copy of the .CSV file and was able to read the contents of the .CSV file via the following connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyLib; Extended Properties='text,HDR=yes;FMT=Delimited;ReadOnlt-false'
I now need to change this connection so that it reads the .csv file (of the same name) from the remote server (Not a SQL server). I change the locally working connection string to:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\remoteServerName\7.7\samples; Extended Properties='text, HDR=yes; FMT= Delimited;ReadOnly=false' ;User ID=MyUserId; Password=MyPassword;
However I receive the following error message: "Cannot Start your application. The workgroup information file is missing or opened exclusively by another user."
Using the supplied remote server name , user Id and password I can manually remote on to the server and edit the .csv document. So what is wrong with the connection string that I cannot connect via my application?