Active3 years, 1 month ago
Netezza Ole Db Provider Download
I tried to see if the Microst OLE DB provider for Oracle is installed or not using the.udl file. The provider tab in.udl file does not show any provider named ' Microsoft OLE DB provider for Oracle'.
I've got a 32 bit .net 2.0 app that uses the Jet OLEDB 4.0.
It runs fin on Windows 8 32 bit, but not on the 64 bit. on 64 bit I'm getting an error:
'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
I am aware that you can't use that database (driver) with a 64 bit EXE. However I've not read anything about it not working with the 32 bit exe.
What I tried:
- Verified that msjet40.dll is in the 'C:WindowsSysWOW64msjet40.dll' directory and registered it with RegSvr32.
So I think (hope) that if I can install the database support it'll just work.
Problem is, I can't find any place to download it.
- Download Microsoft OLE DB Driver for SQL Server.; 2 minutes to read; In this article. APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse. The following version of the Microsoft OLE DB Driver for SQL Server is available for download: Microsoft OLE DB Driver 18.2.2 for SQL Server; See also.
- This article describes the latest versions of Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server (MSOLAP) and where you can download the providers. Microsoft Excel uses MSOLAP to connect to Microsoft SQL Server. However, Excel cannot connect to a SQL Server Analysis Services database if an incorrect version of MSOLAP is used.
Ole Db Provider Download
Clay Nichols
Clay NicholsClay Nichols
6,2672525 gold badges9696 silver badges155155 bronze badges
2 Answers
On modern Windows this driver isn't available by default anymore, but you can download as Microsoft Access Database Engine 2010 Redistributable on the MS site. If your app is 32 bits be sure to download and install the 32 bits variant because to my knowledge the 32 and 64 bit variant cannot coexist.
Depending on how your app locates its db driver, that might be all that's needed. However, if you use an UDL file there's one extra step - you need to edit that file. Unfortunately, on a 64bits machine the wizard used to edit UDL files is 64 bits by default, it won't see the JET driver and just slap whatever driver it finds first in the UDL file. There are 2 ways to solve this issue:
- start the 32 bits UDL wizard like this:
C:Windowssyswow64rundll32.exe 'C:Program Files (x86)Common FilesSystemOle DBoledb32.dll',OpenDSLFile C:pathtoyour.udl
. Note that I could use this technique on a Win7 64 Pro, but it didn't work on a Server 2008R2 (could be my mistake, just mentioning) - open the UDL file in Notepad or another text editor, it should more or less have this format:
https://powerupstack208.weebly.com/manual-arts-high-school-football.html.
[oledb] ; Everything after this line is an OLE DB initstring Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:PathToThedatabase.mdb;Persist Security Info=False
That should allow your app to start correctly.
fvufvu29.6k55 gold badges4949 silver badges7070 bronze badges
Make sure to target x86 on your project in Visual Studio. Manually download kb4023814. This should fix your trouble.
Kyle BlakeKyle Blake