Oracle Data Provider for .NET / ODP.NET - connection string

Question

Dear All I'm using C#[vs2008] and oracle11G [11.2]. I need connection string for remote server. using Oracle Data Provider for .NET / ODP.NET. can someone help me to give the connection string? Thanks in advance thenndral

Krishna Garad · Answer

Yeah you can use it for reference check this .

thenndral · Answer

Hi...Thanks Krishna..

thenndral · Answer

Hai Krishna thanks for your reply. can We use this connection string for ODP.NET Provider? OracleConnection cn=new OracleConnection(Data Source= ;User Id= ;Password= ); Thanks Thenndral

Krishna Garad · Answer

You can try using OracleClient Class of system.data conn string will be like OracleConnection cn=new OracleConnection(Data Source= ;User Id= ;Password= ); Or can try with oledb provider OledbConnection cn=new OledbConnection(Data Source= user id= ;password= ;Provider=msdaora); Even with odbc first create user DSN in your system and use it