/
ODBC DSN Configuration

ODBC DSN Configuration

Owned by Nic Pohl
Last updated: Mar 05, 2018 by Sam PittsVersion comment


      

  *Clicking image will take you back to troubleshooting article list


This article describes a solution to the error message as shown below:

You receive the following Error when trying to run Framework ECM. This is because the ODBC Connection to Framework has not been configured correctly.

Solution:

A common mistake is to use the 64 Bit version of the ODBC Data Source. Following below, you should be able to locate the 32-Bit version.

Editing the settings as below will allow Framework to read and write from the database.

Framework ECM - ODBC DSN Configuration

1. Open Data Sources (ODBC).
2. Select the System DSN tab.
3. Click the Add button. The Create New Data Source dialog will be displayed.
4. Select SQL Native Client for the SQL Server version being used.
5. Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
6. Enter the following details:

  • Name: FworkSQLECM
  • Description (optional): Enter a description for the database connection. For example, Framework ECM.
  • Server: Select the SQL Server from the Server drop-down list.
    OR
    Enter the SQL Server name.


 If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS


7. Click the Next button.
8. Click the Next button.
9. Tick Change the default database to.
10. From the drop-down list select: FworkSQLEcm
11. Click the Next button.
12. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
13. Click the Test Data Source... button.
14. If successful, click the OK button.
15. Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
16. Click the OK button. The Data Sources (ODBC) dialog will close.


Framework License - ODBC DSN Configuration

1. Open Data Sources (ODBC).
2. Select the System DSN tab.
3. Click the Add button. The Create New Data Source dialog will be displayed.
4. Select SQL Native Client for the SQL Server version being used.
5. Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
6. Enter the following details:

  • Name: FworkSQLLic
  • Description (optional): Enter a description for the database connection. For example, Framework ECM.
  • Server: Select the SQL Server from the Server drop-down list.
    OR
    Enter the SQL Server name.


If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS


7. Click the Next button.
8. Click the Next button.
9. Tick Change the default database to.
10. From the drop-down list select: FworkSQLLic
11. Click the Next button.
12. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
13. Click the Test Data Source... button.
14. If successful, click the OK button.
15. Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
16. Click the OK button. The Data Sources (ODBC) dialog will close.

Framework Sales Advice / Sales Advice Master - ODBC DSN Configuration

1. Open Data Sources (ODBC).
2. Select the System DSN tab.
3. Click the Add button. The Create New Data Source dialog will be displayed.
4. Select SQL Native Client for the SQL Server version being used.
5. Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
6. Enter the following details:

  • Name: FworkSQLSA
  • Description (optional): Enter a description for the database connection. For example, Framework ECM.
  • Server: Select the SQL Server from the Server drop-down list.
    OR
    Enter the SQL Server name.

If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS

7. Click the Next button.
8. Click the Next button.
9. Tick Change the default database to.
10. From the drop-down list select: FworkSQLSA (Sometimes also called FworkSQLSAMaster)
11. Click the Next button.
12. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
13. Click the Test Data Source... button.
14. If successful, click the OK button.
15. Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
16. Click the OK button. The Data Sources (ODBC) dialog will close.

Important: Repeat the same steps and create a second Sales Advice ODBC connection to the same database, with the name of the connection 'FworkSQLSAMaster'.

You should then have two ODBC connections pointing to the same database:

  • FworkSQLSA
  • FworkSQLSAMaster



Contact Us

If you are still having issues in relation to this, or any other Framework related issue, please Contact Us.

Related content