...
- Open Data Sources (ODBC).
- Select the System DSN
- Click the Add The Create New Data Source dialog will be displayed.
- Select SQL Native Client 10.0.
- Click the Finish The Create a New Data Source to SQL Server dialog will be displayed.
- Enter the following details:
- Name: FworkSQLSAMaster
- Description (optional): Enter a description for the database connection. For example, Framework Sales Advice Master.
Server: Select the SQL Server from the Server drop-down list.
OR
Enter the SQL Server name.Info If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS
- Click the Next
- Click the Next
- Tick Change the default database to.
From the drop-down list select: FworkSQLSAMaster
Info If your installation does not use a FworkSQLSAMaster database, select the FworkSQLSA database.
- Click the Next
- Click the Finish The ODBC Microsoft SQL Server Setup dialog will be displayed.
- Click the Test Data Source...
- If successful, click the OK
- Click the OK The ODBC Microsoft SQL Server Setup dialog will close.
- Click the OK The Data Sources (ODBC) dialog will close.
...