0 Replies Latest reply: Dec 28, 2011 3:18 PM by 539588 RSS

    Using msdaora in vb.net program

    539588
      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