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
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.
Using Microsoft Access
- In Microsoft Access, create a new database.
- From the
Filemenu, clickGet External Data, and then choose eitherImportorLink Tables.
- From the "Files of Type" list, select
ODBC Databases.
- In the
Select Data Sourcewindow, choose theMachine Data Sourcetab, 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. ClickOK.
- In the
Connectdialog box, enter your Oracle database username and password, and then clickOK.
- 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.
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:
- In Aqua Data Studio, from the menu bar, click
Server, and thenRegister Server.
- Click the
Generaltab.
- Under "RDBMS:", select
Oracle 9i/10g.
- Next to "Name:", enter a name of your choice for this server
registration (e.g.,
OED1).
- From the drop-down list next to "Type:", select
Production.
- Next to "Login Name:" and "Password", enter your Oracle database
username and password, respectively.
- Next to "Connect As:", make sure
Normalis selected.
- Uncheck the box next to
Save password.
- Next to "Host:", enter
dbserv.uits.indiana.edu.
- Next to "Port:", enter
1521.
- Next to "SID:", enter
oed1, and then clickOK.
Connecting
Once the Oracle Oed1 database is registered, to connect:
- In Aqua Data Studio, on the left, beneath "Local Database Servers",
choose the appropriate server name.
- From the menu bar, click
Server, and then clickConnect.
- In the
Authenticatewindow, next to "Login Name:" and "Password", enter your Oracle database username and password, respectively.
- Next to "Connect As:", make sure
Normalis selected, and then clickOK.
- 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.
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. Useoed1_oraunless you encounter problems, in which case tryoed1_ms.
Also see:
Last modified on May 13, 2009.






