Connecting to Oracle DB with C#

[IkarusDowned]

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?

 

[juiio]

Just add SERVER=... to your connection string.

 

[IkarusDowned]

ah, so my new string would be:

con.ConnectionString = "User Id=scott;Password=tiger;Data Source=orcl9i;server = oracle-db.remote.edu;";

then?
I've never heard of this as a solution on other forums, but it's worth a shot. Thanks, i'll let you know how it goes.

 

[IkarusDowned]

Server is an invalid string attribute...unfortunatly...i think you might be thinking of regular SQL connecting? Thanks for the try, though.

 

[kamper]

Case sensitive? You have it lowercase and all the rest start with upper case.

 

[juiio]

Actually for Oracle, try Host=

http://media.datadirect.com/download/do...tnet/dotnetref/dotnetora.html#wp949585