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, 1005👍, 0💬

Popular Posts:

NULLIF() - Replacing...

How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...

Selecting Some Speci...

How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...

Selecting Some Speci...

How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

WHILE ... Loops in S...

How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...