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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' cou

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
 
Hi. I have connected my SSAS in SQL server 2008 to an Oracle database.  I have installed the Oracle ODAC to enable me to set up the Data Source, the Data Source View and the Cube.  Now everything was going fine.  I could connect to the Oracle Database and I could see my tables and pull them into the DSV. But.  When I come to process the Cube it throws these errors.  Why all of a sudden do the connection objects stop working? Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DBIBGEORAclients', Name of 'DBIBGEORAclients'. Can anyone help here please? Thanks, David.


View Complete Post


More Related Resource Links

Errors in the back-end database access module. OLE DB reported an overflow of the data type for colu

  
Getting an error when processing a dimension, Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 0. Errors in the OLAP storage engine: An error occurred while the 'xxxxxx' attribute of the 'Dim XXXXXX' dimension from the 'XXXXXXX' database was being processed. Content of this dimension is very similar to one that is processing no problem. The content of the dimension is one field only of type date.  The original content was imported through SSIS from a DB2 database on an iseries machine.  Thought a first the issue was because of the data contains some null values but the dimension the process OK also has some null  values.  The dimension that processes ok is also a single field of type date. Any help greatly appreciated, Roscoe

Need Oracle Data Provider .CS File for Oracle 10g Database connection !

  

Hi.,

I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query

(eg)

Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");

Gridview1.DataBind();

Plz Post the link if there is any open source !    


SQL and Outlook: Enable Database Access and Updates Through Exchange and Any E-mail Client

  

Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.

Alok Mehta and Daniel Williams

MSDN Magazine January 2002


access Oracle database

  

Pre- .Net Framework 4.0 supported using Oracle.DataAccess.Client, using Oracle.DataAccess.Types, System.Data.OracleClient, OracleDataReader, OracleConnection. What are the equivalents in .Net Framework 4.0? Does it require any download?

Thank you.


Oracle Database access

  
Hello all,I have created an application with VS 2008. It accesses my oracle database (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0) which is on my external harddrive. All of this needs to be accessed remotely. I was told to use Apache, so I install Oracle HTTP Server after a few consultations. I was told I just needed mod_plsql and that I can even use ApEx. I have no clue what to do here. Any suggestions, links to tutorials/wikis are very helpful. My main issue is how to use a page in my application to access the database remotely. Help!Thanks for your time

The provider is not compatible with the version of Oracle client

  
I am having the error stated above. The stack trace is as follows: [OracleException: The provider is not compatible with the version of Oracle client] Oracle.DataAccess.Client.OracleInit.Initialize() +550 Oracle.DataAccess.Client.OracleConnection..cctor() +518 [TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.] Oracle.DataAccess.Client.OracleConnection..ctor() +51 InputForm.SelectRegion() +123 InputForm.Initialize() +952 InputForm.Page_Load(Object sender, EventArgs e) +53 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3048   Some info's: Server: Windows Server 2008 R2 .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1 Oracle.DataAccess, Version=1.102.3.0 Dev Computer: Windows Vista Business 32bit .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1 Oracle.DataAccess, Version=1.102.3.0 My Code: OracleConnection cn;String con1 = ConfigurationManager.ConnectionStrings["myConnectionString"].ToString();cn = new OracleConnection();cn.ConnectionString = con1;cn.Open(); string mysql = "select region_code, 'Region ' || reg_

Access database using client credentials

  
I have created a small wcf project that comprises the following  TZ_PI_Interface_WCF - This is a WCF service hosted in IIS  TZ_PI_Interface_Client - This is a test client The service is running in as much that my client communicates with it and executes code in the service. My client app executes the GetProcessData_GetSearch_Client_Detail of my service.  This method should go off to a database and return some data to the client. For the purposes of this test I am catching exceptions in the GetProcessData_GetSearch_Client_Detail method and returnind the error message as a piece of data. When the GetProcessData_GetSearch_Client_Detail is executed, a connection should be made the a database and data should be returned to the client The results I get depend on my connection string. These are the scenarios I am trying along with the results of executing GetProcessData_GetSearch_Client_Detail 1) Local DB Test using Integrated Security  Connection Error: System.Data.SqlClient.SqlException: Login failed for user 'N075650\ASPNET' 2) Local DB Test using SQL Login  Data correctly returned 3) Remote DB using Integrated Security  Connection Error: System.Data.SqlClient.SqlException: Login failed for user '(null)' 4) Remote DB using SQL Login  Data correctly returned In the live environment I will have the service hosted on an IIS server (6.0) and the

The provider is not compatible with the version of Oracle client

  
We are getting following error message while trying to execute sql package thru 'ExecuteNonQuery' our .NET code. This was working perfectly few days back, but suddenly VS2008 on our local is not able to execute the code. We are not sure what had exactly happened here, but code stopped working  on all develop machine all of sudden    Details for the error are as follows "The provider is not compatible with the version of Oracle client" or sometimes "Typeinitializer exception" We were using oracle.dataacess.dll version 1.102.3.0 which was working fine.It still works fine when we deploy it in the production. We checked the GAC of the developer machines and Server,i found one difference that in the GAC of the server only the 1.102.3.0 is installed while on the developer machines,two version of oracle.client are installed in the GAC,one is 1.102.3.0 and the other is 1.102.4.0 When we run the code,it might be the case that .net framework is picking up 1.102.4.0 and that may be the problem,so we tried to include it in our project and that still gave us the same error !.We requested to uninstall 1.102.4.0 from developer machines but client refuses to uninstall that its security fix and can not remove it ! Than we thought to upgrade the version of oracle.dataacess.dll to 2.102.4.0 and code started working but it started giving onther trouble..which is

SSAS 2008R2 - Enable to process a database using Oracle OraOLEDB data provider

  

Hi,

I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.

In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.

I've created a dimension based on this query with object_id as the key.

I've deployed the solution to the server. All is working fine for the moment.

But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :

"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.

Serveur : L'opération a été annulée.

Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O

connect using Oracle.DataAccess.Client

  

Hi all,

I want to insert some values (from asp.net  web application) in a table on oracle DB that hosted on a machine rather than the machine that hosts the asp.net application

i use "oracle.dataaccess.client" and  the following function

  Function DB_Insert_HIS_ORACLE_cn1(ByVal InsertStatment As String) As Integer

        Dim identity As Integer


        Dim oradb As String = "Data Source=(DESCRIPTION=" _
           + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=150.173.10.61)(PORT=1522)))" _
           + "(CONNECT_DATA=(SERVER=NOOR)(SERVICE_NAME=NOOR)));" _
           + "User Id=via;Password=fly;Connect Timeout=5"

        Dim conn As New OracleConnection(oradb)
        conn.ConnectionString = oradb
        conn.Open()



        Dim sql As String = InsertStatment
        Dim cmd As New OracleCommand(sql, conn)
        cmd.CommandType = CommandType.Text
        identity = cmd.ExecuteNonQuery()

        conn.Close()
        conn.Dispose()



        Return identity

    End Function


but i get the following exception

The type initializer for "Oracle.DataAccess.Client.OracleConnection" threw an exception

please help me knowing that i don't know anything about the machine that hosts the oracle db except the machine name,db

Problem in connecting to oracle database,which is using Provider=MSDAORA.1

  

Hi I am Naveen, I am upgrading a internal website from .Net 1.1 to .Net2.0 in Vb.

The database is deployed in the server, but i could not connect to that database.

i have to connect database to few drop down lists,

my manager has given connection string to me... i have placed it in web.config and given that link properly in the code..

but the database is not connecting.. the list is showing empty..

my conn string is


<add key="D2" value="Provider=MSDAORA.1;Data Source=baan; User ID=xxxx; Password=xxxx;Persist Security Info=True"/>
      


can anyone help me,,, thanks in advance...


Cannot load Access database from SharePoint into client access

  

I'm starting to think this is a bug but here's what happens...

We've just deployed Access Services and are testing it.  I've created a new database on my mysite and can edit it fine via the web interface.  However, if I click Options --> Open in Access, I'm presented with this error message:

"Microsoft Access could not open the Web Application from https://mysite.moss.domain.tld/personal/tim/projects.  Please verify that the server is available."

The server is definitely available.  I'm at a loss here.  I'm using Access 2010.


Oracle.DataAccess.Client very slow

  

When I run my piece of SQL through SQL developer it takes less than half a second with an overall cost of 618 on the explain plan.

When I run the same SQL through .NET via the oracle.dataaccess.client connection it is impossibly slow taking over 5 minutes to run.

What could be causing this and what can I do?


Oracle.DataAccess.Client.OracleException: ORA-03113:end-of-file on communication channel in Oracle 1

  

ORA-03113: end-of-file on communication channel

Exception details: Oracle.DataAccess.Client.OracleException: ORA-03113:end-of-file on communication channel

 My database is Oracle 10g, I am using .NET Framework 3.5 with Visual Studio 2008.

 It happened only once when first time in the morning I open my URL in my test server then this error popup at very first page of my site.

Next time onwars it work perfectly fine.

 Any Idea friends, Have you face the similar error, please tell me in details.

Thanks,

Vivek


The provider is not compatible with the version of Oracle client

  

We are getting following error message while trying to execute sql package thru 'ExecuteNonQuery' our .NET code.

This was working perfectly few days back, but suddenly VS2008 on our local is not able to execute the code.

We are not sure what had exactly happened here, but code stopped working  on all develop machine all of sudden 

 

Details for the error are as follows

"The provider is not compatible with the version of Oracle client" or sometimes "Typeinitializer exception"

We were using oracle.dataacess.dll version 1.102.3.0 which was working fine.It still works fine when we deploy it in the production.

We checked the GAC of the developer machines and Server,i found one difference that in the GAC of the server only the 1.102.3.0 is installed while on the developer machines,two version of oracle.client are installed in the GAC,one is 1.102.3.0 and the other is 1.102.4.0

When we run the code,it might be the case that .net framework is picking up 1.102.4.0 and that may be the problem,so we tried to include it in our project and that still gave us the same error !.We requested to uninstall 1.102.4.0 from developer machines but client refuses to uninstall that its security fix and can not remove it !

Than we thought to upgrade the version of oracle.dataacess.dll to 2.102.4.0 and code started working

Store and Display Images from MS Access Database Using C#

  
There is only the difference of coding syntax to stream the binary data of image content type to upload it into MS Access Database using C#/VB in ASP.Net 2.0

Namespaces required:-
using System.Data.OleDb;

OleDb is used to connect the web site forms with MS Access Database using Microsoft.Jet.OLEDB.4.0

ASP.Net Upload Image to MS Access Database

  
As you learnt from the previous articles to upload image to the SQL Database in ASP.Net 2.0 and stream that image into the memory to retrieve it from the database and display it on the web page. In this article you will learn how to upload images to the MS Access database in ASP.Net 2.0

First of all create an Access Database and place it in the App_Data folder of ASP.Net web site project. Then create a table "tblImg" with the following fields:
Categories: 
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