Home >> FAQs/Tutorials >> Oracle DBA FAQ >> Index

Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection

By: FYIcenter.com

Part:   1  2   3  4  5 

(Continued from previous part...)

How Can Windows Applications Connect to Oracle Servers?

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, becaused 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:
       

How To Create Tables for ODBC Connection Testing?

If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here:

SQL> CONNECT system/retneciyf
Connected.

SQL> CREATE USER fyi IDENTIFIED BY retneciyf ACCOUNT UNLOCK;
User created.

SQL> GRANT CREATE SESSION TO fyi;
Grant succeeded.

SQL> GRANT CREATE TABLE TO fyi;
Grant succeeded.

SQL> ALTER USER fyi DEFAULT TABLESPACE USERS;
User altered.

SQL> ALTER USER dev QUOTA 4M ON USERS;
User altered.

SQL> connect fyi/retneciyf;
Connected.

SQL> CREATE TABLE dev_faq (id NUMBER);
SQL> INSERT INTO dev_faq VALUES (3);
SQL> INSERT INTO dev_faq VALUES (5);
SQL> INSERT INTO dev_faq VALUES (7);

How To Check the Oracle TNS Settings?

If you have installed an Oracle server or an Oracle client tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connect identifiers.

For example, if you have Oracle XE server installed, you will have the tnsnames.ora located at \oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN. It should contain a connect identifier called XE defined as:

XE =
  (DESCRIPTION =
    (ADDRESS = 
      (PROTOCOL = TCP)(HOST = localhost)
      (PORT = 1521)
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

See other tutorials for more details.

(Continued on next part...)

Part:   1  2   3  4  5