Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Unanswered: how to write my connection string for connecting to remote oracle server?

    hi.

    I have used Oracle.DataAccess.dll in my project and want to connect to remote server 192.168.1.20 from my PC which is localhost.I have installed oracle client and connect to XE database with HR user with this connection string via my pc:

    string conStr = "Data Source=XE;user ID=hr;password=hr";
    OracleConnection con=new OracleConnection();
    con.ConnectionString = conStr;

    and it works.But I need to connect to remote server as i said.How should I write my connection string?
    AsI am from MS SQL Server world, if this was the case I would write it as such:

    string conStr = "Server=192.168.1.20;data source=myDB;user id=hhh;password=ps234;";
    SqlConnection con = new SqlConnection(conStr);

    How should i write it in ORACLE with oracle.DataAccess.dll???

    thanks in advance.

  2. #2
    Join Date
    Jan 2012
    Posts
    84
    read documentation:
    Contents
    Here is about connection strings:
    Connecting to Oracle Database

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •