Data Source Name
When using the JDBC-ODBC bridge driver in a statement such as this
Connection conn = DriverManager.getConnection ("jdbc:odbc:orcl",user,passwd);
the word orcl in the "url" is referred to as a data source name.
Using this driver to access our Oracle database it is necessary that "orcl"
be defined as a data source name on the lab computer running your application.
This may be accomlished by the following steps:
For the "Classic View" of Windows,
Click on Start, then Settings, Control Panel, Administrative Tools, then
Data Sources (ODBC);
A page will popup with the title "Microsoft ODBC Administrator;
Click the ADD button and a pull-down menu will appear;
Scroll down and choose "Microsoft ODBC for Oracle", and click "Finish";
A pop-up window will appear with textboxes:
Enter "orcl" (no quotes) in the box labeled Data Source Name and in
the box labeled Server;
Click the OK button and the Microsoft ODBC Administrator window will
reappear;
Click OK again and a data source named orcl will have been defined.
Note: if you are using lynx on the llano server, substitute lynx for orcl.