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