?
Solved

read oracle database

Posted on 2014-01-21
3
Medium Priority
?
270 Views
Last Modified: 2014-01-26
This my first time to try out this.

I have opened the connection to an oracle database using the code below.

  Dim oradb As String = "Data Source=(DESCRIPTION=" _
               + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx)(PORT=1521)))" _
               + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=yyyy)));" _
               + "User Id=uname;Password=pw;"
        Dim conn As New OracleConnection(oradb) ' VB.NET
        conn.Open()

and it is successful.

I want to read the views. but I have no idea.

I have been using like the code below to read data in the PLSQL. where I am told  "mim_ADHOC" is a schema.


select * from mim_ADHOC.vw_marketing_datamart where smonth = 201312;

Help and thank you

Anthony
0
Comment
Question by:Anthony Matovu
  • 2
3 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39797734
What error do you get?
0
 
LVL 1

Accepted Solution

by:
Anthony Matovu earned 0 total points
ID: 39797777
Thank you MikeOM_DBA.

I downloaded the oracle dataprovider for .net 64 bit and I installed it and it worked

Anthony
0
 
LVL 1

Author Closing Comment

by:Anthony Matovu
ID: 39809830
I downloaded the oracle dataprovider for .net 64 bit and I installed it and it worked
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
This article describes and provides a custom-made tool I wrote to give businesses a means of identifying commercial music content, without having to expend too much effort. Business recordings are easily identified from possibly illegal music files …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

589 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