wie kann man zu 'HR' databank in Oracle verbinden?

[javakh]

Hello alle,
Ich wollte mit allen Tabelle in der Datanbankname "HR" in Oracle 10g arbeiten. Leider kann ich keine Verbindung erstellen. Meine Fragen an Euch:
1) wie kann ich 'HR' verbinden, damit ich mit verschiedenen Tabellen wie EMPLOYEES, JOB_GRADES, DEPARTMENTS oder ..... arbeiten kann.
2) wie sieht das Syntax zu 'HR' aus?

Ich danke eure voraus
MFG

[bdittmar]

connection string

Hallo,,

Type: .NET Framework Class Library
Usage: Oracle.DataAccess.Client.OracleConnection
Manufacturer: Oracle
More info about this class library »
Customize string
example values »
Using TNS
Data Source=TORCL;User Id=myUsername;Password=myPassword;


Using integrated security
Data Source=TORCL;Integrated Security=SSPI;


Using ODP.NET without tnsnames.ora
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOC OL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=( SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;


Using the Easy Connect Naming Method (aka EZ Connect)
The easy connect naming method enables clients to connect to a database without any configuration.
Data Source=username/password@//myserver:1521/my.service.com;
Port 1521 is used if no port number is specified in the connection string.

Make sure that EZCONNECT is enabled in the sqlnet.ora file. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

'//' in data source is optional and is there to enable URL style hostname values

Easy Connect Naming Method to connect to an Instance
This one does not specify a service or a port.
Data Source=username/password@myserver//instancename;


Easy Connect Naming Method to connect to a dedicated server instance
This one does not specify a service or a port.
Data Source=username/password@myserver/myservice:dedicated/instancename;
Other server options: SHARED, POOLED (to use instead of DEDICATED). Dedicated is the default.

Welche connect Methode ?

USER@//HOST:PORT/SID !

MFG

[javakh]

vielen bdittmar,
mit deinem Tip werde ich gleich testen.

Schönen Wochenende