Unanswered: accessing oracle database from server without oracle on client
My project is on Visual Basic .Net . In this project i have used Oracle as backend which is on Server. I have used OleDbConnection for connection.
The problem with me is that i would like to run my project on such a machine which wont have oracle installed on it. I want a direct access of database from the Server. So what would i provide as my connection string to access the database from the server. Currently i am using
Dim myconnection As String
Dim mycon As OleDb.OleDbConnection
myconnection = "Provider=MSDAORA.1;Data Source=abc;Password=xyz;User ID=xyz"
myconn = New OleDb.OleDbConnection(myconnection)