Setting up an ODBC Datasource Name for Accounting and Management data
Description
Cause
Resolution

[BCB:4:Operating system warning:ECB]  

Create a User DSN (also called Timberline DSN or ODBC DSN) to access Accounting and Management data. Install Sage 300 CRE on the workstation so the drivers can be available for the DSN.

Set up a User DSN

  1. From the Windows taskbar, click Start and select All Programs, ODBC, 32bit ODBC Administrator.
  2. From the User DSN tab, click Add.
  3. In the Create New Data Source window, select Timberline Data, and then click Finish.
  4. Enter a Data Source Name and specify the Database Type as an Accounting Data Folder.

    NOTE:

    The Data Source Name can be any name unless specified in the documentation for this DSN.

  5. Click Select Folder and select the folder containing the data you want to use.
  6. Click OK.
  7. Click Options.
  8. Specify the Table and Field Naming as Standard descriptions unless otherwise specified in the documentation for this DSN.

    NOTE:

    Field descriptions for miscellaneous fields don't store standard description field names.

  9. If the DSN is for Crystal Reports, select the Use maximum table segment size checkbox.
  10. Clear the Shorten field and table names checkbox.
  11. Click OK and then OK again.

 

 

[BCB:156:Chat 300 CRE US:ECB]

 

Steps to duplicate
Related Solutions

How do I set up an ODBC Pervasive DSN for Purchasing and Inventory data?

How do I set up an ODBC Pervasive DSN for Service Management data?