Prev Next

OLE DB Connection to SQL Server Repository

In order for an Enterprise Architect client to open a SQL Server repository using an OLE DB connection, the client machine must have the SQL Server OLE DB driver installed for the same architecture (32 or 64 bit) that Enterprise Architect uses.

For example, if you are using the 64 bit version of Enterprise Architect, then the client machine will need a 64 bit OLE DB driver, but if you are using the 32 bit version of Enterprise Architect then a 32 OLE DB driver will be required.

Prerequisites

  • A Microsoft SQL Server database server
  • An Enterprise Architect repository defined in the SQL Server database server
  • You know the database user credentials that have SELECT, INSERT, UPDATE, DELETE, EXECUTE access permissions to the Enterprise Architect repository; see the SQL Server Security Permissions Help topic
  • 'Microsoft OLE DB Provider for SQL Server' or 'Microsoft OLE DB Driver for SQL Server' should be installed

Access

Keyboard Shortcuts

Ctrl+O : Connect to Server drop-down arrow : ODBC Connection Wizard

Other

Project list | Open Project : Connect to Server drop-down arrow : ODBC Connection Wizard

Start Page : Manage Projects : Connect to Server drop-down arrow : ODBC Connection Wizard

Install the OLEDB Driver

In the majority of modern Windows Operating Systems there is a 'Microsoft OLE DB Provider for SQL Server' driver installed as part of the Operating System, however this driver is quite old and can not connect to more recent versions of SQL Server database server, therefore a manual install of a newer driver is required.

The OLEDB driver will only need to be install once on each client machine, therefore if your machine already has the appropriate SQL Server ODBC driver installed you can skip to the next step.

Step

Action

1

Download the appropriate SQL Server OLEDB driver for your operating system and architecture (32 or 64 bit) of Enterprise Architect, from the Microsoft website.

If you are interested, the history of the SQL Server OLEDB driver is discussed on this webpage.

2

Run the SQL Server OLEDB driver installer, accepting the default values.

Connect to the Repository

Step

Action

1

In the 'Open Project' dialog, select the 'ODBC Connection Wizard' option available under the Connect to Server drop down.

The Data Link Properties screen is shown

2

Select 'Microsoft OLE DB Provider for SQL Server' or 'Microsoft OLE DB Driver for SQL Server' from the list on the Provider tab.

Note:

  • 'Microsoft OLE DB Provider for SQL Server' is usually part of the Windows Operating System, otherwise it can be installed as part of MDAC 2.8
  • 'Microsoft OLE DB Driver for SQL Server' is a newly released driver that adds support for TLS v1.2 and other more recent features of Microsoft SQL Server (such as multi-subnet failover capabilities); this driver is available from the Microsoft website

3

Click on the Next>> button.

The 'Connection' tab displays.

4

Type in the connection details, including Server Name, User Name, Password and check the Allow saving password option.

5

From the Select the database on the server drop down choose the database name to connect to.

6

Click on the Test Connection button to confirm that the details are correct.

7

If the test does not succeed, revise your settings.

If the test succeeds, click on the OK button.

8

Depending on how the connecting to SQL Server process was started, the 'Connection Name & Type' dialog could be displayed; if so fill in the Name and, if required, check the 'Encrypt Connection String' option.

The Name entered will be the value displayed on the 'Recent Projects' panel on the 'Open Project' dialog, while the Encrypt Connection string option hides the connection details of the database, which is useful for keeping the details secret when you share the connection string with other users.

Notes

  • Connecting to DBMS based Repositories is available in the Corporate, Unified and Ultimate Editions

Learn more