Groups > Databases > Oracle for ASP.NET > Re: Oracle Remote Connection String in ASP.Net




Oracle Remote Connection String in ASP.Net

Oracle Remote Connection String in ASP.Net
Tue, 1 Apr 2008 14:27:45 +0000
I m using Oracle 10g and i want to connect it from a pc in LAN. i m using this
connection string 

Provider=MSDAORA.1;User ID=schema;Data Source=Registra;Persist Security
Info=False

For Example Oralce is installed in PC1 and i want to connect it from PC2. 

what would be changes in connection string.

Further More i want to extract schema of connected data base. User
"schema" is constructed under "SYS".

plz help me.
Post Reply
Re: Oracle Remote Connection String in ASP.Net
Wed, 2 Apr 2008 15:24:04 +0000
Your datasources parameters might be stored into the "tnsnames.ora"
file located in folder network\admin under Oracle installation folder (e.g.
"D:\oracle\ora92\network\ADMIN" for me). At least that's how I'm
working with Oracle. But since we have DBAs I don't know much about its
administration apart from that ^_^;

Look for "Registra" in the file and check if you can modify PC1 (or
its IP address) by PC2. My datasources look like this:

MYDATASOURCE  = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcp)
          (PROTOCOL = TCP)
          (Host = oracleserver.corp)
          (Port = 9999)
        )
    )
    (CONNECT_DATA = (SID = MYDATASOURCE)
    )
  )
Post Reply
about | contact