Home
SQL Image Viewer online help Prev Page Prev Page
Introduction
About SQL Image Viewer
Version history
Contact us
User Guide
System requirements
Editor command selection
Exporting large number of images
Folders and files
Reference Guide
Main menu
Connect to Database
Connecting to Firebird databases
Connecting to MySQL databases
Connecting to Oracle databases
Connecting to SQLite databases
Connecting to SQL Server databases
Connecting using ODBC
Connecting to a DB2 database
Connecting to a PostgreSQL database
Options
General options
Editor options
Thumbnail options
Image view
Check for updates
About
The work area
SQL editor
Table browser
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Exporting Microsoft Access OLE data
Post-processing Office files
Image options
File naming convention
Datetime format specifiers
Command line interface
Parameters, logs and exit codes
Advanced options
CROP option
Troubleshooting
Expired trial
Invalid licenses
Unidentified images or binary data
DICOM images

Connecting to Oracle databases

Click on the Oracle option to open the Oracle connection options.

connect-oracle

Database
Enter the name of the database. The value may be one of the following:

· The server, port, and service descriptor of the database e.g. OraSrv:1521/orcl  

· TNS alias name, specifying the database to connect to e.g. OraSrv  

· The full connection descriptor, as entered in TNSNames.ora e.g.  
 
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = OraSrv)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))  
 
· The full Oracle connection string e.g. scott/tiger@OraSrv  

User name
Enter the name of the database user to connect as.
Password
Enter the password of the database user.


In order to connect to Oracle servers, the Oracle client libraries must be installed. You can use the full client installation set, or the Oracle Instant Client pack. If you are using the Oracle Instant Client pack, the path to the Instant Client folder must be included as part of the system's PATH settings.