How do I connect to the UITS Oracle database Oed1 from the IUB STCs?

You can connect to the Oracle database Oed1 from the Indiana University Bloomington Student Technology Centers (STCs) using the method appropriate to your client.

On this page:

• Using SQL*Plus
• Using Microsoft Access
• Using Aqua Data Studio
• Using other client applications

Using SQL*Plus

When you launch SQL*Plus, enter your Oracle database username, password, and host string. In the STCs, the full Oracle host string, or service name, is oed1.world . Oracle Net names that you configure on your own computer may differ from the STC names, since these can be arbitrarily assigned.

Back to top

Using Microsoft Access

1. In Microsoft Access, create a new database.
   
   
2. From the File menu, click Get External Data, and then choose either Import or Link Tables.
   
   
3. From the "Files of Type" list, select ODBC Databases.
   
   
4. In the Select Data Source window, choose the Machine Data Source tab, and then select your data source. In the STCs, you will see the Data Source Name (DSN) oed1_ora. On other computers, the DSN may be different. Click OK.
   
   
5. In the Connect dialog box, enter your Oracle database username and password, and then click OK.
   
   
6. The list of tables you see will include all of the tables on Oed1. Select the tables you want, and click OK.

Access requires that a table has a primary key field, or else it will prompt you for it before establishing the link. You should see the link in your database window, and you can proceed with your work.

The next time you open the database, the links will still exist unless you explicitly delete them. If you ever change a data source, you'll need to delete and recreate links in order for them to work.

Back to top

Using Aqua Data Studio

To connect to the Oracle database Oed1 using Aqua Data Studio, you must register the database server before connecting.

Registering

To register the Oracle database Oed1:

1. In Aqua Data Studio, from the menu bar, click Server, and then Register Server.
   
   
2. Click the General tab.
   
   
3. Under "RDBMS:", select Oracle 9i/10g.
   
   
4. Next to "Name:", enter a name of your choice for this server registration (e.g., OED1).
   
   
5. From the drop-down list next to "Type:", select Production.
   
   
6. Next to "Login Name:" and "Password", enter your Oracle database username and password, respectively.
   
   
7. Next to "Connect As:", make sure Normal is selected.
   
   
8. Uncheck the box next to Save password.
   
   
9. Next to "Host:", enter dbserv.uits.indiana.edu .
   
   
10. Next to "Port:", enter 1521 .
    
    
11. Next to "SID:", enter oed1 , and then click OK.

Connecting

Once the Oracle Oed1 database is registered, to connect:

1. In Aqua Data Studio, on the left, beneath "Local Database Servers", choose the appropriate server name.
   
   
2. From the menu bar, click Server, and then click Connect.
   
   
3. In the Authenticate window, next to "Login Name:" and "Password", enter your Oracle database username and password, respectively.
   
   
4. Next to "Connect As:", make sure Normal is selected, and then click OK.
   
   
5. On the left, under your server name, double-click Schema, and then double-click your personal schema (the same name as your Oracle database username).

Note: UITS does not support Aqua Data Studio beyond installation from IUware. For technical support, visit the AquaFold support page.

Back to top

Using other client applications

To connect to Oed1 using a client application other than SQL*Plus, Microsoft Access, or Aqua Data Studio in the STCs, you'll need to use an ODBC connection. An ODBC data source is a name set up on the client computer that is associated with specific connection information to a remote database. Refer to the application's help pages for information on making an ODBC connection. The following general information may help you:

• To use an ODBC connection with a client application such as Microsoft Excel, you will need to know the ODBC Data Source Name (DSN) set up on the client computer.
  
  
• The STC computers are set up with an ODBC System (or Machine) DSN for the Oed1 database. The DSN is configured to use the Oracle driver for Oracle and is named oed1_ora .
  
  
• A second DSN is set up to use the Microsoft driver for Oracle and is named oed1_ms . Use oed1_ora unless you encounter problems, in which case try oed1_ms .

Back to top

Also see:

• Oracle database service environments available for instruction at IU