.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

System.InvalidOperationException: The 'IBMDA400.DataSource.1' provider is not registered on the lo

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
I am run the ETL package through the SQL Server Agent, the job fails with the error message "System.InvalidOperationException: The 'IBMDA400.DataSource.1' provider is not registered on the local machine.". But when i run trough the UI is runs fine. I am uisng OLE DB driver to the connect to AS400. can you please tekk ne where a im going wrong.   The  log file entery is as follows    OnProgress,DCMS2100,RBGDC01\SMTSQL_service,LMS_ORDER_HEADER REFRESH,{78FE47C8-9539-4A20-8FC7-BC790204C2F0},{AF7E99E5-653C-4BF5-B5A1-B1E7CE2AEE9E},31/07/2006 19:57:30,31/07/2006 19:57:30,0,0x,ValidatingOnProgress,DCMS2100,RBGDC01\SMTSQL_service,LMS_ORDER_HEADER REFRESH,{78FE47C8-9539-4A20-8FC7-BC790204C2F0},{AF7E99E5-653C-4BF5-B5A1-B1E7CE2AEE9E},31/07/2006 19:57:30,31/07/2006 19:57:30,50,0x,ValidatingOnError,DCMS2100,RBGDC01\SMTSQL_service,LMS_ORDER_HEADER REFRESH,{78FE47C8-9539-4A20-8FC7-BC790204C2F0},{AF7E99E5-653C-4BF5-B5A1-B1E7CE2AEE9E},31/07/2006 19:57:31,31/07/2006 19:57:31,-1073450910,0x,System.InvalidOperationException: The 'IBMDA400.DataSource.1' provider is not registered on the local machine.   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)   at System.Data.OleDb.OleDbConnectionFactory.Cr

View Complete Post

More Related Resource Links

System.InvalidOperationException: Internal .Net Framework Data Provider error 12.



I have created an application in which there are few forms. Each form has fields which are linked to a backend table/tables. My application is supposed to be accessed by multiple users concurrently. I ran a test where I created a class file in windows application and i ran a for loop in it to call the url of my application. I wanted to test the effect of firing around 200 queries to my query engine.

The test code is :

namespace MachineGun


static class Program


/// <summary>

/// The main entry point for the application.

/// </summary>


Fuzz Testing: Create a Custom Test Interface Provider for Team System


Dan Griffin shows the extensibility of Visual Studio 2005 Team Edition for Software Testers by discussing the modification of the existing Test Interface Provider sample in the latest Visual Studio SDK and implements Fuzz Testing.

Dan Griffin

MSDN Magazine November 2007

System.InvalidOperationException: Invalid attempt to read when no data is present.


Invalid attempt to read when no data is present.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present.

Source Error: 

Line 53:             if (reader.HasRows)
Line 54:             {
Line 55:                 Response.Write(reader.GetString(0));

Here is my code:

How can i restrict the user to login only from the system which he registered from the Computer.

Hi,I am Kartheek. ASP.Net Web developer. I got one requirement regarding security.In my website, if one user registered from a computer, we have to allow  that user to be able to access the site from that computer only. If he try to login from another system even in LAN, we have to deny the access.Please help me with this. Thanks in advance,Kartheek Challagundla.kartheekchk86@gmail.com

System.InvalidOperationException: Instance operation is not valid on workflow runtime thread

Am getting the exception related in the title of this article when using the StateMachineWorkflowInstance object to arbitarily set state in my workflow code; and am unsure why.  The code follows below:   500     Protected Overrides Function Execute(ByVal executionContext As System.Workflow.ComponentModel.ActivityExecutionContext) As System.Workflow.ComponentModel.ActivityExecutionStatus   501    502    506         Dim smwi As StateMachineWorkflowInstance = New StateMachineWorkflowInstance(StaticWFRuntime.LocalRuntime, Me.WorkflowInstanceId)   511    512         'set workflow-wide database connection string   513         _connectionString = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString   518    519         Utility.LogEnabled()   520    521         Utility.FoaeaLogger.WriteEntry("Processing TracingApplication.Execute()....", EventLogEntryType.Information)   522         If StaticWFRuntime.LocalRuntime Is Nothing OrElse StaticWFRuntime.LocalRuntime.IsStarted = False Then   523             Utility.FoaeaLogger.WriteEntry("No static RuntimeService object exists!", EventLogEntryType.Warning)   524         End If   525    526         Return MyBase.Execute(executionContext)   527    528     End Function   796     Private Sub gotoState2_ExecuteCode(ByVal sender As System.Object, ByVal e As System.EventArgs)   797    798        

need a simple login page cus my hosting provider system wont allow me to have more than one database

I dont really write html code too well  but I manged to get my web site developed and deployed using the built in features such as drag n drop, master page and user account authentication that make web developing almost a codeless experience. However; my hosting provider system wont allow me to have more than one database, this causes problems becasue when I developed my web app using vb2010 web developer (asp.net v2) I used the built in web config tool to manage users for my site, now after I deployed to my domain it all worked ok with the exeption of the login page, when I tried to log in the system threw a error message saying "database not found." or a page of "gobble-dee-gook" that says the same thing When I contacted support (my hosting provider) they said i have to create a table of users in my database file via 2008 sql server, thats ok I can do that, but my real problem is I dont know how to write appropriate code to reference the table. So heres my problem:  I just want to have some kind of login page with a couple of txtboxes and a click button that maybe using the VB code behind or html checks the input variables "username" "password" against something that is hard coded into vb a string variable or a constant and then branches to Mainmenu.aspx if successfull. I just need it real simple, no fancy stuff just a login s

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

System.InvalidOperationException: Timeout expired.

Hi I am getting the following error on my page:System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at _default.commentCount(Int32 ArtID) at ASP.default_aspx.__DataBind__control4(Object sender, EventArgs e)....I thought I had closed all the connections in my code:Imports System.Data Imports System.Data.SQLClient Partial Class _default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load commentDisplay() End Sub Sub commentDisplay() Dim pageno As Integer = Request.QueryString("page") Dim MyConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("nbb").ConnectionString) Dim MyDataAdapter As SqlDataAdapter MyDataAdapter = New SqlDataAdapter("art_getHomepage", MyConnection) MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure

Farm, SPWebApplication.Lookup, System.InvalidOperationException

Dear all,   I have a piece of code that works well on a standalone SharePoint installation:   public void SetPeoplePickerProperty(string webAppUrl) { // elevate permissions to allow setting of property. SPSecurity.RunWithElevatedPrivileges(delegate() { System.Uri srvrUri = new System.Uri(webAppUrl); SPWebApplication webApp = SPWebApplication.Lookup(srvrUri); if (!webApp.PeoplePickerSettings.OnlySearchWithinSiteCollection) { webApp.PeoplePickerSettings.OnlySearchWithinSiteCollection = true; webApp.Update(); } }); }   When I deploy it to a server farm, I get the following error: System.InvalidOperationException: This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database. To connect this server to the server farm, use the SharePoint Products and Technologies Configuration Wizard, located on the Start menu in Administrative Tools.   at Microsoft.SharePoint.Administration.SPWebApplication.Lookup(Uri requestUri) The user running the query is farm administrator. It has the necessary access to the configuration database. The server running the code is joined to the farm.   Ideas anyone?   Thanks,   Tore.

No mapping exists from object type System.Web.UI.WebControls.Label to a known managed provider nativ

 I'm making the leap to move from vb.net to C#, and I'm getting this crazy error when I try to execute one sp, set a value, and then execute another sp based on the value.   Any suggestions??? proc_GetSectionDetails is my first stored procedure.  From that, I get a value for SectionID, and then use it for the second sp called  proc_GetSectionDetails protected void getSectionContent() { SqlConnection conn = default(SqlConnection); SqlCommand comm = default(SqlCommand); SqlDataReader reader = default(SqlDataReader); string connectionString = ConfigurationManager.ConnectionStrings["123"].ConnectionString; conn = new SqlConnection(connectionString); comm = new SqlCommand(); comm.Connection = conn; comm.CommandType = System.Data.CommandType.StoredProcedure; comm.CommandText = "proc_GetSectionDetails"; comm.Parameters.AddWithValue("SubSectionID", Request.QueryString["SubSectionID"]); conn.Open(); reader = comm.ExecuteReader(); if (reader.Read()) { lblName.Text = Convert.ToString(reader["SubSectionName"]); lblDesc.Text = Convert.ToString(reader["SubSectionDescription"]); Label SubSectionParentID = new Label();

Word Interop - System.InvalidOperationException in System.Windows.Forms.dll



Microsoft Visual Studio 2005 Version 8.0.50727.42 

Microsoft .NET Framework Version 2.0.50727

Word 2003 Interop


I am trying to recreate the "AmbiguousMember" example from p. 31 of Whitechapel's "MS .NET Development for MS Office" using VB instead of VC#.

This involves implementing an event handler for the Word Quit event. In the event handler, I need to toggle the Enabled state of two buttons. This causes the following error:

A first chance exception of type 'System.InvalidOperationException' occurred in System.Windows.Forms.dll

The code behind the Form1 form is shown below. Form1 has two buttons: Button1 "Run Word"; Button2 "Quit Word". The event handler is intended to clean up if the user quits the Word application, and reset the buttons.

A net s

Failed to find or load the registered .Net Framework Data Provider.




I am using enterprise library 5.0,vs.net 2008,oracle 9i,odp.net version.

In machine.config I added the line below in

<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory , Oracle.DataAccess, Version=, Culture=neutral, PublicKeyToken=89b483f429c47342"/>


DbProviderFactory pf = DbProviderFactories.GetFactory("Oracle.DataAcess.Client");

above line is throwing an error.

System.Configuration.ConfigurationErrorsException was unhandled by user code

Message="Failed to find or load the registered .Net Framework Data Provider."


BareMessage="Failed to find or load the registered .Net Framework Data Provider."



at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)

at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)

at testweb2008.Classes.test..ctor(String strKey) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\testweb2008\testweb2008\Classes\test.cs:line 30

at testweb2008._Default.Page_Load(Object sender

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.

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.






The Ole Db provider "MSDAORA" has not been registered


Hi all,

I had fun going on working with Oracle on Windows 7 64 bit which is my development machine. I figured out some alternatives, but now I am trying to add Oracle linked server on Windows 2008 Server machine. I am running Sql Server 2008. I have Oracle client 8i  I can add linked server and map logins to it but when I try to test the connection I get this error.

The Ole Db provider "MSDAORA" has not been registered. Sql Server Error 7403.

I can see it in the Linked Server Provider Strings in the drop down too.

Please help, Thanks.

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;


ReloadTrackingProfiles: System.InvalidOperationException: TrackingListener for instance %0 is not in



I am hosting Workflows (dll based) in a web application. I created my own TrackingService and my own TrackingChannel (code below). When starting a workflow, everything works fine, all events are tracked. After re-building my solution, workflows, that were running before, do not track anything anymore (although they continue execution). Info: On every build, the build number of all assemblies is increased by default.

I tried to reload the tracking profiles after loading workflows (using workflow.ReloadTrackingProfiles();), but this leads to the error above. 

What am I doing wrong?




Here is the code for the tracking service:

    public class EnablerWFTracking : TrackingService {


        private TrackingProfile profile;


        #region Constructor

        public EnablerWFTracking()

            : base() {

            profile = this.CreateTrackingProfile();




        #region CreateTrackingProfile


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