Steps to get connected to an SQL Express Database (full version is the same)
Install Enterprise Architect by selecting its entry in Crossover's Install Software list.
In Crossover click the Bottles button, select the EA bottle, and open Wine Config under the Control Panels section.
Click the Libraries tab.
Search for or add oleaut32 & oledb32. Set those libraries to Native,Builtin.
Start Enterprise Architect.
Select "Connect to Server" -> Connection Wizard
Select "Microsoft OLE DB Provider for SQL Server"
Enter the Name of the Server "SERVERNAME\SQLEXPRESS" (You might have to use windows to get the correct name)
Select "User a specific user name and password" and fill in fields.
Check "Allow saving of password"
Select the Database from the list.
(If the list isn't populated then double check the server name + username/password).
Click OK.
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
Important Information
Tips are provided by the CrossOver Community and Advocates. They are not
intended to be used for official CodeWeavers Support. For that, please visit our
official support pages.
CodeWeavers or its third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes illustrated in our Privacy Policy. You accept the use of cookies or other identifiers by clicking the Acknowledge button.
Andrew Balfour on 2015-02-19 11:25:57
