Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

read an oracle database using vb.net

Posted on 2014-01-21
1
Medium Priority
?
475 Views
Last Modified: 2014-01-21
Dear Experts,

I would want to read an oracle database using my vb.net application.

I have tried the code below and got the error below.


 Dim oradb As String = "Data Source=(DESCRIPTION=" _
               + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx-yyyy.tttt.tt.uu)(PORT=1521)))" _
               + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=bibp)));" _
               + "User Id=userid;Password=userpw;"
  Dim conn As New OracleConnection(oradb)

My computer is a 64 bit and I have been using PLSQL to access the oracle database.

Thank you for your help

Anthony



ttempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
0
Comment
Question by:Anthony Matovu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 2000 total points
ID: 39796283
>>This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

Two choices.
Install 64 bit client components
Force your app to be a 32 bit version (you probably have it set to dynamically choose 32/64 bit depending on OP system).
0

Featured Post

Quiz: What Do These Organizations Have In Common?

Hint: Their teams ended up taking quizzes, too.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that undeā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

722 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