User`s guide

Oracle JDBC for Windows

2-55

dbname can be the service name or the Oracle system identifier (SID) depending on

your specific Oracle database setup. For details, see your tnsnames.ora file, which

is often in <ORACLE_HOME>\NETWORK\ADMIN where <ORACLE_HOME> is the folder

where the database or the Oracle client is installed.

conn = database('dbname','','',...

'Vendor','Oracle','DriverType','oci',...

'Server','sname','PortNumber',123456);

Or, to connect without Windows authentication, use the DriverType name-

value pair argument of database to specify a connection to the database server

by specifying the thin value. For example, the following code assumes you are

connecting to a database named dbname with user name username and password

pwd.

conn = database('dbname','username','pwd',...

'Vendor','Oracle','DriverType','thin',...

'Server','sname','PortNumber',123456);

If you have trouble using the database function to connect to your Oracle database,

try using the full entry in your tnsnames.ora file in the URL string as one

consecutive line. Leave the first argument blank. For example, the following code

assumes the value of the URL name-value pair argument is set to the following

tnsnames.ora file entry for an Oracle database.

conn = database('','username','pwd',...

'Vendor','Oracle',...

'URL',['jdbc:oracle:thin:@(DESCRIPTION = '...

'(ADDRESS = (PROTOCOL = TCP)(HOST = sname)'...

'(PORT = 123456)) (CONNECT_DATA = '...

'(SERVER = DEDICATED) (SERVICE_NAME = dbname) ) )']);

Close the database connection conn.

close(conn)