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
.ConnectionString = "Provider=msdaora.1;Data Source=WCOP01.world;User Id=crdind;Password=xvxvxv64;"
oraok = True
Catch ex As Exception
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?