Issue : Unable to connect using OLEBD

Asked By Irene_Plummer 0 points N/A Posted on - 11/08/2011

I need your help. I am unable to connect using a Native OLEDBMicrosoft Jet 4.0 OLEDB Provider.

I am receiving the following error message “Test connection failed because of an error in initializing provider.

Un recognized database format C:usersvishshDocumentsmydb.accdb”.

Please help me resolve the issue.

• Status: Open
• Question Views: 1130
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: .NET Programming

Best Answer by Eville bandler

Go To Solution

Answered By LoraBalmer 5 points N/A #107811

Issue : Unable to connect using OLEBD

The possible reason is you are using MS Access 64bit version.

• Download 2007 Office System Driver: Data Connectivity Components from here Download Link
• then choose Microsoft Office 12.0 Access Database Engine OLE DB Provider and point it to your .accdb file.

Hope this helps.

About LoraBalmer

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 11/13/2011
• Question Category: .NET Programming

Best Answer

Best Answer

Answered By Eville bandler 5 points N/A #107812

Issue : Unable to connect using OLEBD

Hi Irene_Plummer,

Firstly, you should download & install  OLEDB Provider for Microsoft Office 12.0 Access Database Engine from here: http://www.microsoft.com/en-us/download/details.aspx?id=23734.

Now open SQL Server Management Studio and connect to the desired instance of SQL Server database engine. From the desired database, right click on “tasks” & then select “import data”. Follow on-screen instructions carefuly & select the Data source.

That should solve the problem.

About Eville bandler

Questions
1

Answers
52

Best Answers
29

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: .NET Programming