Jason Laskey
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
Now if this is inserted and a test connection is run it works fine
This 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)
How ever if I change the path to a local path e.g.c:\temp then it works
I have been struggling for two days any help would be appreciated
JasonL
this is the Setting open VS2012>>Model>>Existing Connections.
Then there is a Excel Calandar Data Source
Now if this is inserted and a test connection is run it works fine
This 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)
How ever if I change the path to a local path e.g.c:\temp then it works
I have been struggling for two days any help would be appreciated
JasonL
Which user is running the process? Have you tried right click and run as admin?
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 ?
Another weird idea: Have you tried to map a drive to the share and use that for the path ?
ASKER
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 ...
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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, please can you assist as this issue is now in an urgent status
JasonL
I have tried the recommended and this is still not workingcan 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
ASKER
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
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