read an oracle database using vb.net
Posted on 2014-01-21
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
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.