Solved

read an oracle database using vb.net

Posted on 2014-01-21
1
449 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

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…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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.

685 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