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

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

oledb provider error.

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

sql server 2005 64bit, windows server 64bit oracle client tool 64bit, when I trying to import data test connection getting faile. user name, password and schema name is correct I have teste the same.

Error Discription: if i select microsoft oled db provider for oracle.  cannot create an instance of OLEDB provider "OraOLEDB.Oracle (Microsoft SQL Server, Error 7302)

Error Discription: if i select Oracle Provider for OLEDB

Provider cannot be found. It may not be propery installed(ADODB.Property)


View Complete Post

More Related Resource Links

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

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.

Trying to connect to Microsoft OLEDB Provider for Oracle ...but giving the following error


Hi All,

When I am trying to Connect to Oracle 11g using SSIS OLEDB source adapter ....Its giving me the following error.

TITLE: Connection Manager

Test connection failed because of an error in initializing provider. ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Tried various ways by changing the TNSNames file and Sqlnet file...but I am unable to connect to oracle database...

If any body have any ideas...can you share with me ASAP...Appreciate your help.




OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Syntax error


Hi there.

I have been sitting hours and hours trying to solved this issue with absolutely no luck.

I have the following query:

Code Snippet

DECLARE @sqlScript1 VARCHAR(8000)

-- Import records fron source file (OPENROWSET)

SET @sqlScript1 = 'SELECT * INTO ##tmpOrders FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'' ,

''Excel 8.0;Database=' + @fileName + ''', ''SELECT [Sale Time] AS SaleTime, Ref, [Item Title] AS ItemTitle, [Item Type] AS ItemType, [Item Id] AS ItemId,


DTSWIZARD (import/export utility) - Error trying to use VFP OLEDB provider


A week ago I was using SQL Server 2008 Express and the DTSWIZARD was working fine when I selected the Microsoft OLE DB Provider for Visual FoxPro as the data source for the import data. The wizard only allows me to RUN the import and not SAVE it saying I needed to upgrade to Developer/Enterprise edition of the server to be able to save the attributes of the import (for reuse).

So, I downloaded SQL Server 2008 R2 Enterprise as an MSDNAA (faculty) person. I installed both R2 Enterprise and R2 Express. I don't really need Enterprise (which is good because I cannot get it to START no matter what I try...which is another issue not related to this one I am writing about here).

I now have the version/feature for DTSWIZARD that allows me to save my import attributes (yea!)...however, the problem now is when I select the Microsoft OLE DB Provider for Visual FoxPro as the data source for the import data I get the following error message when I click NEXT: Feature is not available (Microsoft OLE DB Provider for Visual FoxPro). If I click the Properties... button (to select the VFP database) I get this error message: Unexpected Unrecoverable Error  and the wizard quits when I click any of the 3 buttons on that pop up message.

The VFP OLE DB provider is ALIVE AND WELL (I think) on my Windows 7 Ultimate 32-bit laptop as I am

Provider Error




I have a web application and a business class library where all database connections are made. Not periodically but quite often, I get an error in the class library when i execute an oledbcommand. I have no problem defining and opening a connection but as soon as I try to execute a command or fill a table by an oledbadaptor, I get this error:

'SQLOLEDB' failed with no error message available, result code: E_FAIL(0x80004005)

After getting this error, when I reset IIS, everything starts to work perfectly but after a while, the same problem occurs again.

Does anyone have a clue about what might cause this problem?

Thanks in advance



ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismatch


Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.

Below is the information on the server before/after the upgrade.

Before            After

---------       -----------  

Solaris 8      Solaris 10

IDS 9.40     IDS 11.50

The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.

As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.

The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.

I have gone through many articles and it suggest me to set the environement  variable in the server :  DB_LOCALE=en_us.819.

I haven't try this solution but i think that this might not be the best solution.

Is it possible to to to have this settin

Custom Control Design-Time SiteMap Provider Error


Greetings - I was referred here by MSDN forums hope this is the right place -  

I have a custom control (:WebControl) that renders web.sitemap in a specific way. While it runs error free and produces the expected result, at Design-Time it complains

Error Creating Control - MyControl  The provider 'AspNetXmlSiteMapProvider' specified for the defaultProvider does not exist in the providers collection.

I have discovered that the error is cause by this line of code:

string div = string.Format("<div class='{0}' id='{1}'>{2}</div>", this.CssClass, this.ID.ToString(), EnumerateNodesRecursive(SiteMap.RootNode, level));

or more specifically, by the reference to SiteMap.RootNode - I am not clear what is missing thoough because I have configured the SiteMapProvider in web.config as this:

        <add name="AspNetXmlSiteMapProvider" 
             type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" 

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

Server 2008 R2 -> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error mess


So I am using the aspnet_regiis.exe tool to encrypt sections of the web.config in my asp.net applications and services.  I have done this for years successfully on Windows Server 2003 (IIS 6).  However I just moved some apps over to Windows Server 2008 R2 (with IIS 7.5) and I am now receiving the following error at runtime:

"Server was unable to process request. ---> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: Bad Data."

Now I am quite familiar with this process and am stumped at what I have missed this time around.  I have done ALL of the following which typically suffices for the process on the server. PLEASE READ ALL AND DO NOT PROVIDE RESPONSES OR LINKS FOR THINGS I HAVE ALREADY DONE Thanks!!  Wink

  1. Imported the keys to the server using aspnet_regiis -pi  Result: Success
  2. Given FULL permission (using -full switch) using aspnet_regiis -pa to ALL of the following accounts  Result: Success
    1. Using Error Provider with TreeView?

      Can the standard error provider (icon) be used on Treeview nodes? I have one parent node with one child, I want to show the icon next to the parent only and remove the + and - images . Working with VB .NET, but can use a C# example. Thanks much!   

Error with OLE DB Provider

I am trying to connect from Excel 2007 to the analysis service on a different server. When i provide the names instance of the analysis service i am encountering the following error: 'Error with OLE DB Proiver. Could not connect to the redirector. Ensure the the SQLBrowser service is running on the "XXX" server. I am using SQL Server 2008 R2 64bit Enterprise Edition and operating system Windows Server 2008 R2 64bit Enterprise edition. Thank You.System Administrator

Named Pipes provider error - backup script

I have a couple of installs of SQL Server 2005 Express.  One thing it doesn't provide is an agent to schedule jobs so I read where you can use Windows job scheduler to execute a batch job to in turn run a sqlcmd file.  I have that working on one server but on the other server I get the dreaded Name Pipes provider error and it goes on to talk about it may not be setup to allow remote connections.  If I check using Surface Configurator it is set to allow remote connections using both tcpip and named pipes.  To my knowledge all I want it tcpip but I enabled named pipes in an effort to get things working. About the only difference I can see is on the working system the database is a named instance (ie. Servername) versus default instance on the non-working system which shows up as (Servername\SQLEXPRESS).  Hopefully I have my terminology right here. Any tips on how to troubleshoot?  Does it depend on the username I am using?  Domain admin or local server admin or what have you? I should mention I can execute the backup script and it does work.  It is when I run the batch job that it fails. The batch job just says "sqlcmd -i d:\MSSQL_Jobs\backup.sql -o d:\Logs\sqlbackup_output.txt"

error provider control in aspx pages?

how can i add error provider control in an asp.net page using c#..  for example,if i am using a textbox control which prompts the user to fill it on clicking the submit button,how should i make the textbox control to prompt the user. someone help me with this!!! and also reply me if v can use status strip control in aspx pages

Error installing RBS with the FILESTREAM provider

I had intalled RBS on the web application according to this guids http://technet.microsoft.com/en-us/library/ee748631.aspx. In rbs_install_log I can find the message "Product: SQL Remote Blob Storage -- Configuration completed successfully". But I get also the error in same logfile "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections." In content Database no rbs tables have been created.  I try the command line with DBINSTANCE=<instancename> und DBINSTANCE=<servername\instancename>, but I get always the same error. Has anyone the same issue?

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
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