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 appears 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.
-
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 appears.