.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 and local cubes - Attributes&FillAfterCreation ?

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

Hey there;)

I'm building local cubes with an OleDB connection string and the MSOLAP provider in c#. I don't want to use Analsysis Services, in order to do the cube building with less dependencies as possible.

Now there are two questions i wasn't able to find an answer for:

1. Is there a way to set "attributes" for the cube in the OleDB connection string?

2. Is it possible to create a .cub file with structure information only, and fill it later? If it is, how would that work?


Thank you!



View Complete Post

More Related Resource Links

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;


The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.


Server Error in '/' Application.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

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: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Source Error:

Line 485:                OleDbDataAdapter mydata = new OleDbDataAdapter("select * from [Sheet1$]", strconn);
Line 486:                mydata.TableMappings.Add("Table", "ExcelTest");
Line 487:                mydata.Fill(ds);
Line 488:                
Line 489:                StringBuilder strb = new StringBuilder();

Source File: c:\inetpub\vhosts\smswonders.co.in\httpdocs\Users\Quick SMS.aspx.cs    Line: 487

Stack Trace:

Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine- Class Library . win 7 - 64


Hello I wrote a Class Library Program( DLL ) using  VB.Net - It works fine in a 32 bit machine. But when it runs on a 64 bit machine(win 7) . Get this Error:

'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine." Trying to open an access file

I know this is a 64 bit problem and the solution is change the Target Platform to 32 bit instead of Any CPU , In Soluton Properites. But my application is not a windows Form applcaiton(when I built it it created Dll , Not exe ),  therefore  the Target Plat form is not actiavated in the propeties Tab.

Anybody could help me here. My job continuation depends on this. I am base on a contract and now  company is upgrading all machines to 64 and my Test program doesn't work. I already checked and have the latest version of Microsoft Jet. Thanks  for reading.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit we


Hello All,

I get the error 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.', when i am trying to read an excel file.

I have already installed 2007 Office System Driver: Data Connectivity Components available on http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

I can see the entry of the installed driver on the registry.

The web server is a Windows 2003 R2 Enterprise x64 R2 machine.

After installing the driver the machine has been restarted.

Same build works on a similar machine (Similar Hardware/OS). Hence ruled out rebuilding the code in 64 bit settings.


Thanks in advance.

Rahul B



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


Hi All,


I just created some applicaton using C# with Multithreading system, it was running well on x32 operating system. but, because of another reason, i change opetating system to x64. my application is connecting to Oracle database and Mdb database, and just founded problem to connecting Mdb database when i change my application C# to CPU x64, and got error 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

i really confused about this problem, as i know there is no microsoft.jet.oledb.4.0 provider witch supported for x64, even there is got that provider on C:\Windows\SysWOW64 directory, but i don't even know how to make C:\Windows\SysWOW64 as my destination for my connection string provider.

does anyone knows about that problem?

current time, i change provider to @"Provider=Microsoft.ACE.OLEDB.12.0;user id=Admin;Jet OLEDB:Database Password=xxxxxxx;data source=" + Func.BaseDir + "Config.mdb";

and wow, its perfect compiled to x64, and running well on windows server 2008 x64, but i don't know why should i using Microsoft.ACE.OLEDB.12.0 Provider.

my question is, is it ok to using

Local variable scoping in C#

In my previous post, Compiler-generated scopes for local variable declarations, I briefly touched on the issue of multiple meanings applied to the same name. In this post, I'll aim to flush out the compiler's rules with regards to binding names in their local scopes.

Compiler-generated scopes for local variable declarations

I was tasked with understanding and fixing a bug on error reporting with foreach iteration variables the other day, and it got me thinking about local variable scoping rules in C# in general. First, the bug.

Insert data to Excel using OLEDB



I am trying to insert data to Excel Document using OLEDB as follows:-

 sql = "Insert into [MyFirstSheet$] (" + Title1 + "," +Title2 + "," + Title3 + ") 
values('" + Value1 + "','" + Value2 + "','" + Value2 + "')";
myCommand.CommandText = sql;

 sql = "Insert into [MyFirstSheet$] (" + Title1 + "," +Title2 + "," + Title3 + ") 

values('" + Value1 + "','" + Value2 + "','" + Value2 + "')";

myCommand.CommandText = sql;


But, the Title1 ,Title2, Title3 are in the 3rd row of the Excel Document. So, the data is not inserted.

How to authenticate local user usin ldap or non domain authentication



I created one application, and I need to authenticate local user. This user is the user who is login to his/her Personal Computer.. Main thing his that he/she does not in any DOMAIN... I want NON-DOMAIN authentication.. any how.... please help...

Changing from Local to WCF


I've been handed an application thats connection string implies a local host connection.

I want to make this connection a remote connection, to a database located on a Server.  I want the client and server to be able to communicate with one another remotely, instead of a local connection.

How does one create the Data Service, and establish end points to Server and Client?  Is it as simple as creating a contract (which I have limited knowledge on constructing), between the two locations, setting up the dataservice, security, and ratifying the 'connetions'?

A smidge of insight, please ;-)

Custom Attributes + Reflection


I recently started messing around with custom attributes and reflection. In my code below GetCustomAttributes never return a list (it should return atleast one):

Am i defining the custom attrib wrong?

public class GOrder:IOrder
        public string CertProductIDString { get; set; }

        public string GetRESTParams()
            string data = string.Empty;
                System.Reflection.MemberInfo inf = this.GetType();
                object[] attributes;
                attributes =  inf.GetCustomAttributes(typeof(RESTParamAttrib), true);
                foreach (Object attribute in attributes)
                    RESTParamAttrib attrib = (RESTParamAttrib)attribute;
                    data = data + string.Format("\nData: {0}", attrib.Param);

            catch (Exception ex)

                throw ex;

            return data;

    public class RESTParamAttrib:System.Attribute
        public RESTParamAttrib (string param)
            Param = param;

        public string

Foundations: Workflow Services for Local Communication


This month's column describes how to use WCF for communication between a workflow and a host application in Windows Workflow Foundation 3. This knowledge should help developers with their efforts using WF3 and prepare them for WF4, where WCF is the only abstraction over queues (referred to as "bookmarks" in WF4) that ships with the framework.

Matthew Milner

MSDN Magazine November 2009

Basic Instincts: Designing With Custom Attributes


One of the most powerful aspects of the Microsoft® . NET Framework is its support for attributes. Attribute-based programming is extremely powerful because it adds a declarative dimension to designing and writing software.

Ted Pattison

MSDN Magazine May 2005

C++ Attributes: Make COM Programming a Breeze with New Feature in Visual Studio .NET


C++ attributes in Visual Studio .NET are used to generate C++ code through attribute providers. Attribute providers generate code for COM classes, and the code is injected by the C++ compiler at compile time. This has the effect of reducing the amount of code that you need to write. In addition, with C++ attributes you no longer need to maintain separate IDL and RGS files, which makes project management simpler. This article explains C++ attributes, the process used by the attribute provider to generate code, and the code that is automatically generated. It also covers how attributes affect the registration process, how attributes can be used to generate code module entry points, and how connection points can be implemented using C++ attributes. Also explained is how these features contribute to the Unified Event Model for the .NET platform.

Richard Grimes

MSDN Magazine April 2001

Trying to launch a .exe file on my local computer from intranet site.


I have been told I can launch a local program on my PC from my intranet site but it has to be done with Active X or vbscript and not javascript.  I found the following little sample html code that will launch notepad.  However, I cannot figure out how to put this in a button, etc., within my aspx or code behind to execute it.  Does anybody have any idea how to do this?  I have a lot of javascript code I am launching urls with and I have even tried using that but again, I have been told that to do it client side it needs to be vbscript or something like this.  Any ideas?

  <title>Web page that runs EXE files</title>
  <h1>Web page that runs EXE files</h1>
  <p>Click <a href="file:///C:/windows/notepad.exe" class="navbar">here</a>
  to run notepad.exe (Windows XP, ME, 98, 95)</p>
  <p>Click <a href="file:///C:/winnt/notepad.exe" class="navbar">here</a>
  to run notepad.exe (Windows 2000, NT)</p>


Which ComponentModel.DataAnnotations attributes are used in the Dynamic Data metadata classes?


This namespace contains a lot of attributes for use in, I'm sure, many different applications. I'm curious to know which subset of the attributes in this namespace can be and are used in the Dynamic Data proxy class system, where the entity class is given an attribute that specifies a metadata type. That type contains properties with the same names as properties in the entity class, and the metadata provider builds MetaColumns using attributes on properties in these 'buddy' (proxy') classes.

So far my list includes, from System.ComponentModel.DataAnnotations:

Required, Range, DisplayFormat, StringLength, UIHint, DataType, Regular Expression, Display Column, Editable, and CustomValidation.

And from System.ComponentModel:

DisplayName, Description, and DefaultValue.

Am I missing any?

This was originally asked by myself on StackOverflow at: http://stackoverflow.com/questions/3537356/which-componentmodel-dataannotations-attributes-are-used-in-the-dynamic-data-meta

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

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