Link to home
Start Free TrialLog in
Avatar of Jason Laskey
Jason LaskeyFlag for South Africa

asked on

The Operation failed because the source database does not exist

I have tried a few attempts in resolving this error in MS VS 2012 .
this is the Setting open VS2012>>Model>>Existing Connections.
Then there is a Excel Calandar Data Source
User generated imageNow if this is inserted and a test connection is run it works fine
User generated imageThis is the following error. ( I have checked the permissions on the server for security groups and have made sure all the permissions are correct i.e. as a test I have given everyone full permissions to the below UNC)
User generated imageHow ever if I change the path to a local path e.g.c:\temp then it works
User generated image
I have been struggling for two days any help would be appreciated
JasonL
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Which user is running the process? Have you tried right click and run as admin?
Avatar of Jason Laskey

ASKER

Hi CodeCruiser yes I have tried doing that, its the domain user and he has domain admin rights and full access to the share
Besides of the access rights, could it be possible that the file is already open on the network share (another user has opened it exclusive) ?

Another weird idea: Have you tried to map a drive to the share and use that for the path ?
Yea have tried the mapped drive same error, maybe I am checking it wrong but can you give me a brief explanation how to see if the excel file is in use and then kill the process, cause as mentioned when its saved to c:\temp\calendar.xlsx it works
Most simple: Try to open it with Excel. If it nags about "is in use ... open write protected ?", you're on the right path.

If it's a process on your own system, you could use Sysinternal's (now Microsoft's) Process Explorer to identify the culprit (here's a HowTo). Unfortunately on a network share another user might have that file open ... in that case I have no actual clue how to find the offending user/machine/process ...
I would assume that 'Microsoft Access database Engine' is the wrong odbc driver for accessing a remote excel file.

you might check whether you could use the data source and associated odbc driver used by the 'test connection' rather than forcing it to access db engine.

Sara
I'm not so confident that it's the driver ... Jason told that it works when the file is stored local.
ASKER CERTIFIED SOLUTION
Avatar of sarabande
sarabande
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Team,

I have tried the recommended and this is still not working, please can you assist as this issue is now in an urgent status

JasonL
I have tried the recommended and this is still not working
can you give some more info what you tried and what didn't work?

for example if you always get the same error message despite of making changes, then the changes obviously would not apply.

if the error message shows a file path which either don't exist or which is exclusively opened by another user, you should try to find the file in the explorer and open it with excel while the message is still showing. then, tell us your results.

Sara
Sarabande:

You were very close pointed me out in the right direction, the way I fixed this was Open Visual Studio Model>>Existing Connections.
Select the connection and click Edit
Then Select Impersonation and change the information from Service account to Specific Windows user name and password.
Put in the users creds and then run the process table and viola process/query works 100%

Thanks you everyone for your help appreciate it
Then Select Impersonation and change the information from Service account to Specific Windows user name and password.

a service which is logged in to  Local System account has local administrator rights but no network access. that's why access to remote datasource failed.

you should have accepted your own comment (0 points) rather than give the points to me with an 'average' grade. this grade is not appropriate if my comment helped. if it didn't help you shouldn't award points.

Sara