Issue : Unable to connect using OLEBD

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Eville bandler
Answered By 0 points N/A #107811

Issue : Unable to connect using OLEBD

qa-featured

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.

Best Answer
Best Answer
Answered By 0 points N/A #107812

Issue : Unable to connect using OLEBD

qa-featured

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.

Login/Register to Answer

Related Questions