LINGO installs an SQL script that can be run by the SQL Plus utility in Oracle to build a small database for the TRANDB.LG4 transportation model. The script file is named TRANDB.SQL and may be found in the SAMPLES folder off the main LINGO directory. Here is the procedure you will need to follow to set up this data source:
| 1. | Start up the SQL Plus utility provided with Oracle by going to the Start menu in Windows, select the Run command, type "SQLPLUSW", and then click on the OK button. |
| 2. | Enter your Oracle User ID and password. If you have a default installation of Oracle, the User ID "sys" and the password "change_on_install" should be valid. A host name is required only if Oracle is running remotely. |
| 3. | Run the TRANDB.SQL script by typing "@\LINGO\SAMPLES\TRANDB.SQL" to the SQL Plus system prompt. |
| 4. | Exit SQL Plus by entering "EXIT" to the prompt. |
| 5. | Start up the ODBC Administrator as described in the previous section. |
| 6. | When selecting an ODBC driver, be sure to use the "Microsoft ODBC for Oracle" driver. Do not use the "Oracle ODBC Driver", because it does not provide all the necessary functionality. |
| 7. | Assign the data source the name "Transportation". |
| 8. | Load TRANDB.LG4 into LINGO and solve it. |
| 9. | Enter your Oracle User ID and password as prompted. |
| Note: | If you would like to avoid entering your Oracle User ID and password each time LINGO accesses a database, you may set them once at the start of your session with the File|Database User Info command. |
