Create a connection to a relational database
The first step in setting up a relational database is to set up the connection. After creating the connection, a Configure window is displayed where you set up the connection to the server and database, including authentication.
-
Open the
Add New Connection window
by following these steps:
-
On the
Project tab, in the
Configuration group, select
Project Settings
.
- Click the Databases tab to view the databases settings.
- Under Relational Connections, click Add.
-
On the
Project tab, in the
Configuration group, select
Project Settings
-
In the
"Select a connection type" field, select the type of relational database you
are using:
-
Microsoft SQL Server
-
ODBC
-
Oracle
-
- In the Name field, type a name to identify the connection.
-
Click
OK.
The Configure Connection window for the type of database you selected is displayed.