This discussion is archived
0 Replies Latest reply: Dec 28, 2011 1:18 PM by 539588 RSS

Using msdaora in vb.net program

539588 Newbie
Currently Being Moderated
I am converting a vb6 application to vb.net 2008. The old app uses msdaora. On my win7 development machine i downloaded and installed instantclient 11 2, including sqlplus. Added the instantclient directory to the path=, copied the tnsnames.ora from the xp machine, attached to the vpn and fired sqlplus: it works!

Now the application:
dbORA = New OleDb.OleDbConnection
With dbORA
.ConnectionString = "Provider=msdaora.1;Data Source=WCOP01.world;User Id=crdind;Password=xvxvxv64;"
Try
dbORA.Open()
oraok = True
Catch ex As Exception
MsgBox(ex.Message)
End Try
End With

This gives an oracle error 12154 Could not resolve the connect identifier specified.
This happens whether i have the vpn connection open or not, so it is obviously in my machine.
Does anyone have a suggestion?

Thank you,

Jos

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points