0 Replies Latest reply on Dec 28, 2011 9:18 PM by 539588

    Using msdaora in vb.net program

      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;"
      oraok = True
      Catch ex As Exception
      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,