.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

provider can not be found OLEDB in windows 7

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine also provider can not be found it may not be properly installed I am getting this error I am using windows 7 everything was working fine on XP but on windows 7 i am getting this error I dont understand what to do since I need to run the code as it is very urgent can u please help me with what do I need to do and from where to download the content so that my laptop works properly.... I need to run my project on laptop which is installed with windows 7 -- 64 bits and the project was developed on XP thank u in advance

View Complete Post

More Related Resource Links

Timers: Implement a Continuously Updating, High-Resolution Time Provider for Windows


The timestamps that you can obtain from Windows NT are limited to a maximum resolution of 10 or 15 milliseconds, depending on the underlying hardware. At times, such as when you need to timetag frequent events, it is desirable to achieve a higher resolution. For example, what if you want to be able to contact a thread or perform some other task at intervals more frequent than 10 milliseconds? Suggested ways of achieving better resolution include using performance counters in conjunction with the sytem time to calculate smaller time increments. But using performance counters is a technique that presents its own problems. This article shows one possible way of overcoming limitations inherent in this approach.

Johan Nilsson

MSDN Magazine March 2004

Connect to MS Access via OLEDB provider


I am attempting to use the 64-bit OLEDB Provider for Access found in the "Microsoft Access Database Engine 2010 Redistributable" to connect to and query an Access 2003 database that is on another server separate from my SharePoint server. I have not had any success making the connection. My SharePoint server is Windows Server 2008 SP2 and I am running MOSS 2007 (patched up to the April 2010 CU)

Here is the connection info in my Application Definition XML:

    <LobSystemInstance Name="LessonsLearnedDevOLEDB_Instance">
        <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>
        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">OleDb</Property>
        <Property Name="rdbconnectionData Source" Type="System.String">\\server1\share1\Lessons.mdb</Property>
        <Property Name="rdbconnectionProvider" Type="System.String&qu

oledb provider for db2 and "?" parameter

Ok, i'm working with db2 trow oledb provider(ssrs 2008) When i try the following query in query designe i have the following error: "the number of host variables specified is not equal to the number of parameter markers "   <!-- @page { margin: 2cm } P { margin-bottom: 0.21cm } --> SELECT t.FIMPTOT, (CASE WHEN (t.Pct_To_Total > 0) AND (t.Pct_To_Total < 1) THEN 1 ELSE INTEGER(t .Pct_To_Total) END) Percentage FROM (SELECT FIMPTOT, SUM(NUMRIP) NUMRIP, (double(COUNT(NUMRIP)) * 100 / (SELECT COUNT(NUMRIP) FROM DB2DA.TAB1INDI WHERE FIMPTOT > '0' AND ANNORIFE = ? AND SIGPRO =? AND CODCOM = ? AND CSC BETWEEN ? AND ? ) )Pct_To_Total FROM DB2DA.TAB1INDI WHERE FIMPTOT > '0' AND ANNORIFE = ? AND SIGPRO =? AND CODCOM = ? AND CSC BETWEEN ? AND ? GROUP BY FIMPTOT) t please help me ;-)

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered

Dear All, I am getting the below error while converting Excel 2007 file into text format with my customization. Error: 'The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered' Enviromnet : Windows Server 2008 Enterprise 64 bit with SP2 and SQL Server 2008 64 bit installed. Some times its working fine when i registerd C:\Program Files (x86)\Common Files\System\Ole DB\sqloledb.dll file through regsvr32 and restarting SQL Server. But after few days again i am getting the same error. Can some one help me in resolving this issue. Regards, Jignesh

The provider reported an unexpected catestrophic failure using BETA MICROSOFT.ACE.OLEDB.14.0 drivers

I'm just in the process of converting my app to be able to support text importing via "OPENROWSET" in 64 bit SQL Server using the Beta MICROSOFT.ACE.OLEDB.14.0 drivers.  I've previously used the MICROSOFT.ACE.OLEDB.12.0 drivers but of course these only work on 32 bit instances of SQL Server.  I've found that after I've installed the beta that the connections wont work if I use MICROSOFT.ACE.OLEDB.14.0 as the provider.  However if I use MICROSOFT.ACE.OLEDB.12.0 it works... sort of... I can import data a few times then I get a "The provider reported an unexpected catestrophic failure" error and the app hangs.My environment is 64-bit Windows 7 running VM Workstation, with a 64-bit Windows 7 guest running SQL Server 2008 64 Bit.  Essentially I'm running the following which works... occasionally getting the failure above select top 50 * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=c:\temp\captell;HDR=Yes', 'SELECT * FROM [DASDGIGS0013046591395.TXT]')and select top 50 * FROM OPENROWSET('Microsoft.ACE.OLEDB.14.0','Text;Database=c:\temp\captell;HDR=Yes', 'SELECT * FROM [DASDGIGS0013046591395.TXT]')Which doesn't work, returning the "OLEDB provider ... has not been registered" message.So I'm thinking that the drivers are 64-bit drivers but the registration process during installation is using

Disable SharePoint Workspace alert on Windows 7 PC with Norton Firewall Provider.

My wife has a laptop with Windows 7 and Office 2010.  Recently she was playing with some settings on her PC and did something which now causes a "Microsoft SharePoint Workspace" alert to appear when she boots up the machine. She wants this message to go away.  I do not know how to do this, and searching for portions of the alert have lead nowhere.  Here is the exact message. SharePoint Workspace is unable to communicate through your firewall and will run with limited functionality.  To resolve this problem, enable SharePoint workspace as a Windows Firewall exception.  For assistance, contact your Windows administrator. To remedy this, here is what I attempted: Start > Control Panel > View by Small Icons > Windows Firewall This opens a dialog with the caption, "Help protect your computer with Windows Firewall".  Below that, there is an orange box with the notification, "These settings are being managed by vendor application NORTON FIREWALL PROVIDER." Of the half-dozen options that appear in the left navigation panel of that dialog, only 3 are enabled: control panel home, advanced settings, and troubleshoot my network.  The option to "Turn windows firewall on or off" is disabled. We have Norton 360, so I opened that program and chose the "Settings" tab, which displays a Firewall link to

Weird Exception: Method not found: 'Double System.Windows.Controls.ScrollViewer.get_ContentHorizon

Hi guys I have an XBAP application that uses a Xamdatagrid from Infragistics. I have some filtering on this grid, that rebinds after a filter. The problem is, when a user has scrolled to a certain point and then filters, the rebinding causes the grid to scroll to the beginning position of the grid. Now how I solve this is by getting an instance of the ScrollViewer, I get the ScrollViewer.ContentHorizontalOffset and then I do a ScrollViewer.ScrollToHorizontalOffset after it filters.   Now here comes the problem. For 99% of the users of this xbap app, this will work absolutely fine. Most, if not all of the users run exactly the same machines, XP 64 bit with 8GB RAM. The other 1% get the error: Method not found: 'Double System.Windows.Controls.ScrollViewer.get_ContentHorizontalOffset()'. I cannot reproduce this error on my own box, our dev server or our production server, it is a phantom exception that only pops up on a certain condition. I have even wrapped the "offending" code in a try catch and it still doesn't solve it. If I set the DispatcherUnhandledExceptionArgs Handled to true, it works, but it doesn't feel right. How is this possible? If the method doesn't exist, how can it compile? Why does that method exist for 99% of the other users running the exact same machines? I have googled my fingers raw without any valid results and this issue is frustrat

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access

Hi,I am importing Excel 2007 file into SqlServer 2005 (Sqlexpress). The office 2007 is not installed in the machine. I have downloaded and installed "AccessDatabaseEngine". When I execute following statement SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\File1.xlsx', 'SELECT * FROM [Sheet1$]');The following error is comming:Msg 7399, Level 16, State 1, Line 1The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.Msg 7350, Level 16, State 2, Line 1Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".Can any one suggest what should I do to resolve?Thanks,Parmeshthee. Learning .Net 3.5

Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.40' has been denied.

Hi all,   I am currently working on a stored procedure in SQL 2000 where I use OPENROWSET function to read data from an Excel file into a temporary table.   It works fine when I logged in with username 'sa' and psswrd 'sa' but when I log in with another user name and password I get the following error: "Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.40' has been denied. You must access this provider through a linked server."   I am using VB 6.0 as front end. Is there anyway i can overcome this error?   Please help.   Dhiraj

SQL 2005: Error 15401 - Windows NT user or **group** not found


I have a fresh install of Windows Server 2008 R2 x64 Standard Edition and SQL Server 2005 x64 on top of that, with Service Pack 3. This server, SERV, is in DOMAINA which trusts (one-way) DOMAINB.

When I try to create a login for a group in my domain, I get the following error:
Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49
Windows NT user or group 'DOMAINA\groupname' not found. Check the name again.

I get the same error whether using "create login [domaina\groupname] from widnows", "sp_grantlogin [domaina\groupname]" or Manangement Studio.
This happens ONLY for groups , both in DOMAINA and DOMAINB domains. I can add individual users from both A and B and local computer. For local computer groups: I can add default Windows groups (like Users, Guests, Event Log Readers) by [BUILTIN\Event Log Readers], etc. but not by SERV\Event Log Readers; for custom created group MyLocal it's the other way around: I can via SERV\MyLocal but not via BUILTIN\MyLocal.

If I add a domain group from either DOMAINA or DOMAINB to a local group, whether my own or builtin, I can login to SQL Server remotely using creditentials of a user who belongs to that group (user DOMAINB\ux belongs to DOMAINB\group and DOMAINB\group to SERV\MyLocal). After sp_grantlogin [serv\mylocal] of cours

need help with sharepoint (wss 3.0) with Windows authentication and Custom Role provider

I'm trying to setup sharepoint(wss 3.0) to use my custom role provider with Windows authentication. I've modified the web.config to enable role manager and I am able to select my custom roles when assigning permissions but it doesn't seem like sharepoint is check the permission again my custom roles. If I enable Forms authentication and use my custom membership provider it all works as expected but I do not want to use FBA because of the issues with Client Integration. Essentially I want all the features that comes with the default windows authentications but just have permission be control from my custom role provider. Can anyone offer any solution or suggestions?

Windows 7 on Acer Extensa 5635Z ODBC diver not found



I need to use the ODBC data source Administrator, but when I click on MS Access Database it says 'the setup routines for the Microsoft Access driver (*.mdb) ODBC driver cannot be found.  Please reinstall driver.

I have read all the diolouge between you and others in a forum and I cannot find the file odbcad32.exe to run in my folder under c:\windows\Syswow64:


what do I do?  reply on warsiiqbal@hotmail.com if you can


Authorization Manager (AzMan) as role provider with Windows integrated authentication in SharePoint


Hi all,

First I will describe my environment: Windows Server 2008 R2 x64, IIS 7, SQL Server 2008 and MOSS 2007 Enterprise Edition SP2 x64.

I am trying to setup SharePoint 2007 portal to use Windows integrated authentication with Authorization Manager (AzMan) as role provider.

I have set up an authorization store and defined a set of roles in there. Further I configured the web.configs of my SharePoint environment to use AzMan as role provider.

In IIS I see the roles appearing, but unfortunately those roles are not available in my SharePoint portal. I also see notification in IIS stating that Forms authentication has to be used

What should I do to configure it correctly? Is it even possible to use AzMan with Windows authentication in SharePoint 2007?

Thanks in advance.

With kind regards,




Getting Error "The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered". when importi



I am using below sql command to import the excel file (created in excel 2007). 
SELECt * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=C:\File1.xlsx', 'SELECT * FROM [Sheet1$]');

This command is working fine on the machine which have the office 2007. But, I am getting following error message when I run this command on the server on which the office 2007 is not installed:

Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

Not able to see microsoft oledb provider for oracle in sql server 2005 providers



can any one help me, environment window server 2003  64 bit and sql server 2005 sp3 64 bit and i have installed oracle client  10g 32 bit. problem is, I am not able to see the provider name  while creating linked server.

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered


Hi All,

I am getting the below error while executing the opendatasource statement

SELECT ParamName, ParamDate,ParamNumber,ParamChar

FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

'Data Source= c:\testcmd\misc\CSTARIntegrationParameters.xls;Extended properties=Excel 8.0')...[CSTARIntegrationParameters$]

Error :

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered

Enviromnet :

Windows 2003 64 bit with SP1 and sql 2005 installed.

Same code is executing fine in my local machine which is XP 32 bit.

Can some one help me in resolving this issue.

Also when I tried to check the providers by expanding the linked servers node in the SQL server management studio . i couldnt found the provider for jet.






Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.IO;

using System.Data.OleDb;

using System.Data;

namespace WebApplication1


    public partial class WebUserControl1 : System.Web.UI.UserControl


        protected void Page_Load(object sender, EventArgs e)



        protected void Button1_Click(object sender, EventArgs e)


            OleDbDataAdapter myCommand = null;

            DataSet myDataSet = null;


            DataTable dtExcelInfo = null;

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend