connection string for office 365

Question

connection string for office 365

Anonymous

Hi

I have a Console Aoolication (in c#) and I am trying to connect to an MS access DataBase. but the connection string i tried did not work.

This is the one I used:

"Provider = Microsoft.ACE.OLEDB.365.0; Data Source = C:\Users\ghadd\Desktop\programing\projects\ConsoleApp1\Database1.accdb; Persist Security Info = False;".

this string resulted in an exception that is saying:

System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'

what is the problem?

the office i have is office 365

thanks!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

1 answer

Answer 1

> Provider = Microsoft.ACE.OLEDB.365.0

This provider does not exist.

Provider = Microsoft.ACE.OLEDB.12.0

Download from

https://www.microsoft.com/en-us/download/details.aspx?id=54920

and be sure to carefully read all instructions on that page.

There is a long and technical explanation why your existing version of Access cannot be used, but I will spare you.

Share via

connection string for office 365

1 answer