How to connect to Oracle 10g server from client machines

Posted by Tareq on Stack Overflow See other posts from Stack Overflow or by Tareq
Published on 2010-03-09T06:49:53Z Indexed on 2010/03/09 6:51 UTC
Read the original article Hit count: 261

Filed under:
|

I have installed Oracle 10g in one of my office's computer. I want to keep this as database server. I am developing a .net project which will communicate with the database server from client machine and from the server machine. I success to communicate with oracle from server machine but not from client machine using the .net project. The connection code is as follows:

Public OraConn As ADODB.Connection  
OraConn = New ADODB.Connection  
OraConn.Provider = "OraOLEDB.Oracle"  
OraConn.ConnectionString = "Data Source=<my_database_name>;User ID=<my_user>;Password=<my_pass>;"  
OraConn.Open()  

Please tell me step by step procedures how can I connect to my server database from my .net client program resides on client machine ?

Thanks in Advance.

© Stack Overflow or respective owner

Related posts about oracle10g

Related posts about vb.net