1) Download Oracle Instant client from Oracle page
a) first the "Basic Instant Client Package"
b) then the "ODBC Instant Client Package"
2) Unzip the Basic package in a folder such as "c:\InstantClient"
3) Copy the files contained in the ODBC package in the folder created previously.
4) Execute the file odbc_install.exe
5) Create in the Instant client folder the file tnsnames.ora and follow the below format:
servicename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = serverip)
(PORT = serverport)
)
)
(CONNECT_DATA =
(SID = sidname)
)
)
6) Add the directory to the PATH system environment variable
7) Define the TNS_ADMIN environment variable to point the tnsnames.ora file.
8) Now it's possible creating a odbc
That's all
a) first the "Basic Instant Client Package"
b) then the "ODBC Instant Client Package"
2) Unzip the Basic package in a folder such as "c:\InstantClient"
3) Copy the files contained in the ODBC package in the folder created previously.
4) Execute the file odbc_install.exe
5) Create in the Instant client folder the file tnsnames.ora and follow the below format:
servicename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = serverip)
(PORT = serverport)
)
)
(CONNECT_DATA =
(SID = sidname)
)
)
6) Add the directory to the PATH system environment variable
7) Define the TNS_ADMIN environment variable to point the tnsnames.ora file.
8) Now it's possible creating a odbc
 |
| ODBC to connect Oracle DB - select "Control Panel" from Start Menù |
 |
| ODBC to connect Oracle DB - select "System and Security" in the Control Panel |
 |
| ODBC to connect Oracle DB - select "Administration Tools" |
 |
| ODBC to connect Oracle DB - select "Data Sources (ODBC)" |
 |
| ODBC to connect Oracle DB - Add a new odbc in System DSN |
 |
| ODBC to connect Oracle DB - Select Oracle's driver |
 |
| ODBC to connect Oracle DB - Select the TNS Service Name configurated in the tnsnames.ora |
That's all
Nessun commento:
Posta un commento