• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1630
  • Last Modified:

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
Image-001.pngNow if this is inserted and a test connection is run it works fine
Image-002.pngThis 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)
Image003.pngHow ever if I change the path to a local path e.g.c:\temp then it works
image004.png
I have been struggling for two days any help would be appreciated
JasonL
0
Jason Laskey
Asked:
Jason Laskey
  • 4
  • 4
  • 3
  • +1
1 Solution
 
CodeCruiserCommented:
Which user is running the process? Have you tried right click and run as admin?
0
 
Jason LaskeyICT Systems and Network EngineerAuthor Commented:
Hi CodeCruiser yes I have tried doing that, its the domain user and he has domain admin rights and full access to the share
0
 
frankhelkCommented:
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 ?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
Jason LaskeyICT Systems and Network EngineerAuthor Commented:
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
0
 
frankhelkCommented:
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 ...
0
 
sarabandeCommented:
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
0
 
frankhelkCommented:
I'm not so confident that it's the driver ... Jason told that it works when the file is stored local.
0
 
sarabandeCommented:
Jason told that it works when the file is stored local.
the error message tells that the access db engine was used for odbc access. I know there is an excel odbc driver and it is a good chance that the excel driver is more suitable for the task.

access can use excel files as input data. I think that is done by automation with a local excel. I doubt that the same could work with a remote excel file.

Sara
0
 
Jason LaskeyICT Systems and Network EngineerAuthor Commented:
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
0
 
sarabandeCommented:
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
0
 
Jason LaskeyICT Systems and Network EngineerAuthor Commented:
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
1
 
sarabandeCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 4
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now