Oracle 11g ODBC connection string and configuration

First install ha-instant Client-v11.2.0.3.0-x86.rar

：

Ftp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x86.rar

Ftp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x64.rar

Then perform the installation of ODBC a must choose to install

Add environment variable: Tns_admin value:%oracleclient%/network/admin

Modify Tnsnames.ora to add the server information that needs to be connected,

Note the service_name in Connect_data must be added to ensure normal connection

Network/admin/tnsnames.ora

ORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.109) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

Oracle ODBC Connection string Driver={oracle 11g ODBC DRIVER};UID=SYSTEM;PWD=MANAGER;DATABASE=ORCL; servername=192.168.2.75; Port=1521;dbq=orcl
Dbq:tns Service Name

Windows:

1. Configuring a good service (Oracle Net Manager)

2. Start monitoring

3. Start the configured service

4. The application uses this connection string DRIVER={***};UID=SYSTEM;PWD=MANAGER;DATABASE=ORCL; servername=192.168.0.109; port=1521;

* * * In the connection string above by looking up the name of the Oracle driver in Odbcad32

Oracle 11g ODBC connection string and configuration