VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found
-
Hi, We have a VB.2010 32 bit Windows Desktop program that has been running for years. It uses an Excel (2010 in this case) database which is accessed through a connectionless OLEDB connection string as Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE='L:\accnt\CustomerFiles\DATABASE 2015.xlsm'; Extended Properties="Excel 12.0 Xml;HDR=YES" Normally it works fine but on some systems we get a 3706 Provider cannot be found. It has failed and worked on different W2012R2 systems. It also has failed on Windows 8.1 (64b). On W8.1 have tried installing AccessDataEngine_x64 but it did not help (32 bit version would not install). Can anyone help?
-
Hi, We have a VB.2010 32 bit Windows Desktop program that has been running for years. It uses an Excel (2010 in this case) database which is accessed through a connectionless OLEDB connection string as Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE='L:\accnt\CustomerFiles\DATABASE 2015.xlsm'; Extended Properties="Excel 12.0 Xml;HDR=YES" Normally it works fine but on some systems we get a 3706 Provider cannot be found. It has failed and worked on different W2012R2 systems. It also has failed on Windows 8.1 (64b). On W8.1 have tried installing AccessDataEngine_x64 but it did not help (32 bit version would not install). Can anyone help?
Did you turn it off and turn it back on again?
-
Hi, We have a VB.2010 32 bit Windows Desktop program that has been running for years. It uses an Excel (2010 in this case) database which is accessed through a connectionless OLEDB connection string as Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE='L:\accnt\CustomerFiles\DATABASE 2015.xlsm'; Extended Properties="Excel 12.0 Xml;HDR=YES" Normally it works fine but on some systems we get a 3706 Provider cannot be found. It has failed and worked on different W2012R2 systems. It also has failed on Windows 8.1 (64b). On W8.1 have tried installing AccessDataEngine_x64 but it did not help (32 bit version would not install). Can anyone help?
The problem is that your application is 32 bit so it requires a 32 bit driver. In order to get the current application working you should install 32 bit version. Try downloading it from https://www.microsoft.com/en-us/download/details.aspx?id=13255[^]. Another option is to compile the application as 64 bit and use the 64 bit driver.
-
The problem is that your application is 32 bit so it requires a 32 bit driver. In order to get the current application working you should install 32 bit version. Try downloading it from https://www.microsoft.com/en-us/download/details.aspx?id=13255[^]. Another option is to compile the application as 64 bit and use the 64 bit driver.
As I said below that will not install. Error message=You cannot install the 32 bit version of Microsoft Access Database Engine 2010 because you current have 64-but Office products installed. If you want to install 32-bit installation of Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), return setup in order to install 32-but version of Microsoft Access Database Engine 2010: Microsoft Office Standard 2010. I really do not want to uninstall Office. I do not know if my customers have the 32 bit versions or would be using them. Seems like the 64-bit version is pre-installed on some machines.
-
Did you turn it off and turn it back on again?
Turn what off and on again? AccessDatabaseEngine_64 was installed, rebooted, test failed, uninstalled AccessDatabaseEngine_64, rebooted still fails.
-
As I said below that will not install. Error message=You cannot install the 32 bit version of Microsoft Access Database Engine 2010 because you current have 64-but Office products installed. If you want to install 32-bit installation of Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), return setup in order to install 32-but version of Microsoft Access Database Engine 2010: Microsoft Office Standard 2010. I really do not want to uninstall Office. I do not know if my customers have the 32 bit versions or would be using them. Seems like the 64-bit version is pre-installed on some machines.
QuickBooksDev wrote:
I really do not want to uninstall Office
You don't need to install ACE on a system that already has Office.
-
As I said below that will not install. Error message=You cannot install the 32 bit version of Microsoft Access Database Engine 2010 because you current have 64-but Office products installed. If you want to install 32-bit installation of Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), return setup in order to install 32-but version of Microsoft Access Database Engine 2010: Microsoft Office Standard 2010. I really do not want to uninstall Office. I do not know if my customers have the 32 bit versions or would be using them. Seems like the 64-bit version is pre-installed on some machines.
-
Can't an interface that the program uses for QuickBooks requires 32bit.
-
QuickBooksDev wrote:
I really do not want to uninstall Office
You don't need to install ACE on a system that already has Office.
Ok, then what should I do to make it work. I was just following other postings on the web and some said that ACE was needed. If not great but it still does not work.
-
Ok, then what should I do to make it work. I was just following other postings on the web and some said that ACE was needed. If not great but it still does not work.
ACE is included with Office.
-
QuickBooksDev wrote:
I really do not want to uninstall Office
You don't need to install ACE on a system that already has Office.
What do I have to do to make it work? I cannot change the program to 64bit.
-
As I said below that will not install. Error message=You cannot install the 32 bit version of Microsoft Access Database Engine 2010 because you current have 64-but Office products installed. If you want to install 32-bit installation of Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), return setup in order to install 32-but version of Microsoft Access Database Engine 2010: Microsoft Office Standard 2010. I really do not want to uninstall Office. I do not know if my customers have the 32 bit versions or would be using them. Seems like the 64-bit version is pre-installed on some machines.
If you've got a 64-bit version of Office installed, you can't install the 32-bit driver. There doesn't seem to be a sensible reason for this, but you'd have to ask Microsoft for a definitive answer. Depending on the files you're reading, you might be able to get away with installing the Office 2007 version[^] of the driver, as suggested in this SO answer[^]. The 2007 drivers were 32-bit only, and shouldn't be blocked by the 64-bit version of Office 2010.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
