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
Jason LaskeyICT Systems and Network EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.