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: 346
        
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