|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
#1 |
|
Member (8 bit)
Join Date: Jun 2001
Posts: 169
|
Connect to remote Oracle DB with C#?
Hey all,
I'm a complete n00b with C# and using the ODB.NET stuff, but i was looking at the basic tutorials on connecting to an Oracle DB. The thing is, they all seem to have a local DB running. what i mean is, in the line: con.ConnectionString = "User Id=scott;Password=tiger;Data Source=orcl9i;"; they have Data Source as just the orcl9i. my database is indeed 9i, but i have to connect to it thru a remote connection...so, lets just say for example the DB is connecatble at oracle-db.remote.edu and i have the login name and pw. What do i do to connect to this? Just replace the orcl9i with my remote location? |
|
|
|
|
|
#2 |
|
Member (8 bit)
Join Date: Jun 2001
Posts: 169
|
using the following code:
string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=csil-server1.cs.uiuc.edu)(PORT=1521)))" + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));"+ "User Id=xxxx;Password=xxxx;"; i get the following error: ORA-12560: TNS rotocol adapter errorany ideas? |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|