Oracle - Windows Applications Connect to Oracle Servers in Oracle

Windows Applications Connect to Oracle Servers in Oracle

Q

How Can Windows Applications Connect to Oracle Servers in Oracle?

✍: FYIcenter.com

A

A Windows application can connect to an Oracle server directly, if it knows how to use the Oracle TNS technology.

A Windows application can connect to an Oracle server indirectly through Windows ODBC manager, because it offers ODBC drivers to support the ODBC API. The diagram below shows how MS Access can connect to an Oracle server through the ODBC driver:
Oracle ODBC Connection

⇒ODBC Drivers and DSN Configuration for Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 487👍, 0💬

Popular Posts:

DDL (Data Definition...

What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...

Downloading and Inst...

How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

Downloading and Inst...

How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...

What Causes Index Fr...

What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...