Page History
...
| Info |
|---|
If you already have the Oracle ODBC client and ODBC driver installed and are able to successfully establish ODBC connections to your Oracle database on the network using another ODBC-aware application (such as Microsoft Excel, for example), then you can proceed directly to Adding an Oracle database component in MapForce using ODBC. |
There are several ways to obtain, install, and configure the necessary Oracle client and ODBC software. Following are some observations from our own experience during testing with Oracle and creating these examples.
...
- Install and use the full Oracle client instead
- Create the TNS Service Names on a different computer that has with the necessary programs, and then copy TNSNAMES.ORA to your client's computer.
- Manually create and edit the TNSNAMES.ORA file using a plain text editor such as Notepad. To do this, you need to know the format and content of the file. Some of the links provided below describe the format and content of the file and/or provide examples.
...
Following are some references that provide more information on TNS Service Names, their definition, and the alternate SQL Connect URL form. There are many more references available on the Internet. Use your Internet search engine to locate further references if required.
...