Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: How can I get OLEDB 12.0 for Windows 8 to use with Delphi 2010?


This question is answered.


Permlink Replies: 2 - Last Post: Jan 21, 2016 12:12 PM Last Post By: Shobha Choudhari
Shobha Choudhari

Posts: 2
Registered: 9/1/01
How can I get OLEDB 12.0 for Windows 8 to use with Delphi 2010?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 21, 2016 9:33 AM
Hi,

I just installed Delphi 2010 on a new PC with Window 8.
I was trying to run the database application on Win 8 that I have developed using Delphi 2010 on Windows 7.
To connect to the MS Acsess database (.accdb) using ADO, I used the conn str: Provider=Microsoft.ACE.OLEDB.12.0" on Win 7.

However, it does not work on Win 8 with Delphi 2010. It gives an error message "provider can not be found". OLEDB 12.0 is not available in the provider list on Win 8. No other drivers worked.
So, I downloaded 64-bit MS Access Databases Engine 2010 Redistributable file from MS site; but it did not install OLEDB 12.0. It doesn't allow to install 32-bit version file.

How can I get OLEDB 12.0 for Windows 8? How can I make my program work on Win 8 with the same Delphi 2010 software?

Thank you.

Shobha

Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: How can I get OLEDB 12.0 for Windows 8 to use with Delphi 2010?
Correct
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 21, 2016 9:51 AM   in response to: Shobha Choudhari in response to: Shobha Choudhari
Shobha Choudhari wrote:
Hi,

I just installed Delphi 2010 on a new PC with Window 8.
I was trying to run the database application on Win 8 that I have developed using Delphi 2010 on Windows 7.
To connect to the MS Acsess database (.accdb) using ADO, I used the conn str: Provider=Microsoft.ACE.OLEDB.12.0" on Win 7.

However, it does not work on Win 8 with Delphi 2010. It gives an error message "provider can not be found". OLEDB 12.0 is not available in the provider list on Win 8. No other drivers worked.
So, I downloaded 64-bit MS Access Databases Engine 2010 Redistributable file from MS site; but it did not install OLEDB 12.0. It doesn't allow to install 32-bit version file.

How can I get OLEDB 12.0 for Windows 8? How can I make my program work on Win 8 with the same Delphi 2010 software?

Thank you.

Shobha


Try the 2007 drivers, this link I beleive is the 32 bit drivers

https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

This thread is where I got hte link and people who installed it says it now works.

https://social.msdn.microsoft.com/Forums/en-US/f11b2df9-fd0a-4528-987f-f95dfdccee0a/microsoftaceoledb120-provider-is-not-registered-on-the-local-machine-error?forum=adodotnetdataproviders

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Shobha Choudhari

Posts: 2
Registered: 9/1/01
Re: How can I get OLEDB 12.0 for Windows 8 to use with Delphi 2010?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 21, 2016 12:12 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Jeff Overcash (TeamB) wrote:
Shobha Choudhari wrote:
Hi,

I just installed Delphi 2010 on a new PC with Window 8.
I was trying to run the database application on Win 8 that I have developed using Delphi 2010 on Windows 7.
To connect to the MS Acsess database (.accdb) using ADO, I used the conn str: Provider=Microsoft.ACE.OLEDB.12.0" on Win 7.

However, it does not work on Win 8 with Delphi 2010. It gives an error message "provider can not be found". OLEDB 12.0 is not available in the provider list on Win 8. No other drivers worked.
So, I downloaded 64-bit MS Access Databases Engine 2010 Redistributable file from MS site; but it did not install OLEDB 12.0. It doesn't allow to install 32-bit version file.

How can I get OLEDB 12.0 for Windows 8? How can I make my program work on Win 8 with the same Delphi 2010 software?

Thank you.

Shobha


Try the 2007 drivers, this link I beleive is the 32 bit drivers

https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

This thread is where I got hte link and people who installed it says it now works.

https://social.msdn.microsoft.com/Forums/en-US/f11b2df9-fd0a-4528-987f-f95dfdccee0a/microsoftaceoledb120-provider-is-not-registered-on-the-local-machine-error?forum=adodotnetdataproviders

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Jeff,

Thank you very much. I used the 2007 driver from the link and it actually worked. It installed OleDB 12.0 driver and my program worked. Thanks.
Shobha

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02