...
- Open Windows Explorer.
Browse to: \[fw folder]\Setup\Database - MSSQL\Microsoft - SQL Server Native Client Driver\
Info Install the correct Microsoft SQL Server Native Client Driver (either 2005 or 2008) based on the version of Microsoft SQL Server installed on the server. - Double-click the relevant setup file. The Microsoft SQL Server Native Client installation will begin.
- Click the Next The Licence Agreement step will be displayed.
- Select I accept the terms in the licence agreement.
- Click the Next The Registration Information step will be displayed.
- Enter the registration details.
- Click the Next The Feature Selection step will be displayed.
- Click the Next The Ready To Install the Program step will be displayed.
- Click the Install button to begin the installation.
- Click the Finish button to complete the installation.
...
- 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
- 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.
...