Add a relational database connection
Use the procedure in this topic to add a relational database connection that can later be referenced by a 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.
-
On the
Project tab, in the
Configuration group, select
Project Settings.
- Select the Databases tab.
-
In the
Relational Connections group, select
Add.
The Add New Connection window is displayed.
-
In the
Add New Connection window, configure the following settings.
Setting
Description
Select a connection type
Select the type of relational database you are using from Microsoft SQL Server, ODBC, or Oracle.
Name
Enter a name to identify a connection when defining a database.
-
Select
OK.
A configuration window for the type of database you selected is displayed.
-
Depending on the connection type, configure one of the following database connection: