Solved

read an oracle database using vb.net

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Loop not working 29 48
Runtime Error 2 29
'G_F01' is not a procedure or is undefined 3 13
Distinct values from all columns in a table?? PL SQL 4 25
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

864 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

23 Experts available now in Live!

Get 1:1 Help Now