Oracle data warehouse

Posted on 2004-11-08
Last Modified: 2010-04-23
Have you ever worked with Oracle data warehouse using dotNET?

I've search over internet but found little documents. Do you know how to connect to the datawarehouse and do somethings such as create a (Crystal Report) report?

Question by:ehanoi2
    LVL 1

    Author Comment

    Does a data warehouse similar to a database in ways: create and use stored procedure?

    It seems that Data Warehouse is rarely to be used, doesn't it? :(
    LVL 8

    Accepted Solution

    i use data warehouse, and have dabbled with what you are trying to do.  ive been able to create a connection to the database, but cannot run any queries.

    the reason i think the queries always fail is becuase we have a "special version" MS Access interface we run all our DWH queries with.  However, DWH is on an Oracle machine.

    this leads me to believe that they are using two different standards of SQL and our MS Access program is what does the converting the code to the server.

    so in short, heres how i connect to DWH

            'self made function

            'correct connection string through ADO
            conn.ConnectionString = "DSN=YourInfo;server=YourInfo;uid=" + login + ";pwd=" + pass

            Catch ex As Exception
                MsgBox("Cannot connect to DataWarehouse.  Could be a connection problem or invalid UserName/Pass.  Please try again.")
            End Try

    if you make sure you get the connection string correct, it will work.  however, best of luck trying to run queries on it.  i couldnt get it to work.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now