Solved

read an oracle database using vb.net

Posted on 2014-01-21
1
448 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
1 Comment
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 500 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

789 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