Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Previous revision | ||
knowledge-base:database-migration:setup-and-troubleshooting:oracle:odbc-driver-configuration [2018/08/01 11:26] |
knowledge-base:database-migration:setup-and-troubleshooting:oracle:odbc-driver-configuration [2023/12/15 09:07] (current) volha.zhyrava |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | \\ | ||
+ | [[https://www.ispirer.com|Ispirer Website]] | ||
+ | [[https://www.ispirer.com/products/oracle-migration|Ispirer Capabilities: Oracle Migration]] | ||
+ | [[https://www.ispirer.com/download/download-demo|Free Trial]] | ||
+ | ====== Oracle: ODBC Driver Configuration ====== | ||
+ | Please, follow the following steps to specify the ODBC connection: | ||
+ | |||
+ | a. Please go to the "ODBC Administrator" choose the TAB "System DSN" and click "Add". Choose the appropriate Oracle Driver. See the picture: | ||
+ | |||
+ | {{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_conf_1.jpg?nolink|}} | ||
+ | |||
+ | Click "Finish". | ||
+ | |||
+ | b. Specify the "Data Source Name" - the name for the ODBC connection. Choose the "[[knowledge-base/database-migration/setup-and-troubleshooting/oracle/tns-configuration|TNS Service Name]]" from the drop-down menu. Specify the default "User ID" to use for the connection. Click "Test Connection". | ||
+ | |||
+ | {{:knowledge-base:database-migration:setup-and-troubleshooting:oracle:ora_odbc_conf_2.jpg?nolink|}} | ||
+ | |||
+ | If the connection is successful you are ready to use this ODBC Connection for the connection to the Oracle Server. | ||
+ | |||
+ | \\ | ||
+ | If you have any other questions, please contact us: [[[email protected]]] |