| 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' v18.x should be installed
Access
|
Keyboard Shortcuts |
: Connect to Server drop-down arrow : ODBC Connection Wizard |
|
Other |
Start Page : Manage Projects : Connect to Server drop-down arrow : ODBC Connection Wizard |
| Open Project : Connect to Server drop-down arrow : ODBC Connection WizardInstall 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 OLEDB driver installed you can skip to the next step.
Step |
Action |
|---|---|
|
1 |
Download the appropriate SQL Server OLEDB driver v18.x 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:
|
|
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 to confirm that the details are correct. |
|
7 |
If the test does not succeed, revise your settings. If the test succeeds, click on the . |
|
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