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)
myconn.Open()

Waiting for your reply on meera_panchal@yahoo.co.in

Thanking you