Enterprise Architect 10.x Tips

Steps to get connected to an SQL Express Database (full version is the same)

1. Install Enterprise Architect by selecting its entry in Crossover's Install Software list.
2. In Crossover go to the Configure menu, Manage Bottles, select the EA bottle, Control Panel tab, Wine Config.
3. Click the Libraries tab.
4. Search for or add oleaut32 & oledb32. Set those libraries to Native,Builtin.
5. Start Enterprise Architect.
6. Select "Connect to Server" -> Connection Wizard Select "Microsoft OLE DB Provider for SQL Server"
7. Enter the Name of the Server "SERVERNAME\SQLEXPRESS" (You might have to use windows to get the correct name)
8. Select "User a specific user name and password" and fill in fields.
9. Check "Allow saving of password"
10. Select the Database from the list. (If the list isn't populated then double check the server name + username/password). Click OK.
11. Just accept the defaults EA provides (like Lazy Load). Create a Log file.

If EA prompts that the database isn't valid. Try re-registering the oledb32.dll from the "Program Files\Common\System\Ole DB" directory. Note: All problems experienced when connecting to a DBMS come from the oleaut32 and oledb32 dll's