[BCB:4:Operating system warning:ECB]

 

Set up/create a User DSN (also referred to as a Timberline DSN or ODBC DSN) to access Accounting and Management data. Sage 300 Construction and Real Estate must be installed on the workstation for the proper drivers to be available for the DSN.

To set up a User DSN, complete the following steps:

1. From the Windows task bar, 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 then specify the Database Type as an Accounting Data Folder. The Data Source Name can be any name unless otherwise specified in documentation for which you are using this DSN.
5. Click Select Folder and then select the folder that contains 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 documentation for which you are using this DSN. Note: For more information about Table and Field Naming, refer to How do I determine what ODBC Options to use for the DSN?
9. If the DSN is for Crystal Reports, select the Use maximum table segment size check box.
10. Clear the Shorten field and table names check box.
11. Click OK.
12. Click OK.

Notes:

• To set up a DSN for use with Purchasing (PO) and Inventory (IV), refer to How do I set up an ODBC Pervasive DSN for Purchasing and Inventory data?
• To set up a DSN for use with Service Management (SM), refer to How do I set up an ODBC Pervasive DSN for Service Management data?

 

Note: Field descriptions associated with Miscellaneous fields that can be customized in Setup windows (as opposed to in Custom Descriptions) do not store a standard description field names. For further information refer to How do I determine what ODBC Options to use for the DSN?