enigmasolutions
asked on
Office 12.0 Access - OLE DB Provider Not Listed in my Delphi Application (using ADO)
Hi,
I am trying to import data from MS Access 2010 using...
Provider=Microsoft.ACE.OLE DB.12.0.
I have written a large delphi application uing tADOConnection to import data from external applications. When I run my program on my PC and open up the "Data Link Properties" then the above provider is not listed.
But if I run MS Excel 2010 it is listed as one of the providers.
Also when I test my program on another PC it is listed as one of the providers.
So what do I need to do to my PC to get this provider made available to my application.
I tried downloading and installing the driver from here...
http://www.microsoft.com/download/en/details.aspx?id=23734
I am trying to import data from MS Access 2010 using...
Provider=Microsoft.ACE.OLE
I have written a large delphi application uing tADOConnection to import data from external applications. When I run my program on my PC and open up the "Data Link Properties" then the above provider is not listed.
But if I run MS Excel 2010 it is listed as one of the providers.
Also when I test my program on another PC it is listed as one of the providers.
So what do I need to do to my PC to get this provider made available to my application.
I tried downloading and installing the driver from here...
http://www.microsoft.com/download/en/details.aspx?id=23734
It might be that.
I know with Crystal Reports we have to use the ODBC drivers MS provided. They never provided an OLE driver for MS Access or Excel for Office 2007 or 2010 if we want to use files in the new format as accdb or xlsx.
mlmcc
I know with Crystal Reports we have to use the ODBC drivers MS provided. They never provided an OLE driver for MS Access or Excel for Office 2007 or 2010 if we want to use files in the new format as accdb or xlsx.
mlmcc
ASKER
Thanks for the ideas.
I don't know what "bit-ness" is but we compile our application on two different PCs... on one PC it works on the other it does not. The Delphi App is compiled to 32-bit. Both PCs are running Win 7 64 bit.
Long shot... Is there some check in the registry I could look for???
mimcc, I was think along those lines, which is why I downloaded the MS ODBC drivers and instaleld them.
Still Stumped...
I don't know what "bit-ness" is but we compile our application on two different PCs... on one PC it works on the other it does not. The Delphi App is compiled to 32-bit. Both PCs are running Win 7 64 bit.
Long shot... Is there some check in the registry I could look for???
mimcc, I was think along those lines, which is why I downloaded the MS ODBC drivers and instaleld them.
Still Stumped...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I agree it has to be a difference in how it was installed.
How do you configure the "Microsoft.ACE.OLEDB.12.0. " provider to run in 32-bit mode?
How do you configure the "Microsoft.ACE.OLEDB.12.0.
See if downloading and installing 32 bit version(top one) from here helps
http://www.microsoft.com/download/en/details.aspx?id=13255
http://www.microsoft.com/download/en/details.aspx?id=13255
ASKER
Sorry for the slow response...
The 32 bit would not install - because I have "64-bit Office products installed".
The 32 bit would not install - because I have "64-bit Office products installed".
ASKER
Wow. That's strange.
When I tested my application today the provider now appears in my application.
Gosh, I guess all I had to do was reboot my PC.
I am sure I tried that.
When I tested my application today the provider now appears in my application.
Gosh, I guess all I had to do was reboot my PC.
I am sure I tried that.
ASKER
mimcc,
You get the points.
I suspect the re-install of the driver fixed the problem after rebooting.
Who knows...?
You get the points.
I suspect the re-install of the driver fixed the problem after rebooting.
Who knows...?
Is your app being built in a different bit-ness from the version of Office you have installed?