Knowledge Base
PROGRAM: DataPlus for Sage 100 - Messages or Errors

Table of Contents
Sage 100 ODBC
Related FAQs
Sage ODBC 2023
ProvideX ODBC
    Data Source Administrator
  1. Open ODBC Data Sources (64bit)
  2. Click on Tab System DSN
ProvideX ODBC
    System DSN
  1. Click on Name S100_ABC
  2. Click on button Configure...
ProvideX ODBC
    System DSN
    Basic
  1. Data Source Name: S100_ABC
  2. Description: DataPlus Link Server
  3. Database Directory: C:\Sage\Sage 100\MAS90
  4. Definition File: Leave Blank
ProvideX ODBC
    System DSN
    Server
  1. Server Name or IP: Leave Blank
  2. TCP/IIP Port: Leave Blank
ProvideX ODBC
    System DSN
    Logon
  1. Company code: YourCompanyCode
  2. Default UserID: YourUserID
  3. Password: YourUserPassword
  4. Session: Leave Blank
ProvideX ODBC
    System DSN
    Options
    Option 1
  1. Prefix for data files: C:\Sage\Sage 100\MAS90\SY\, C:\Sage\Sage 100\MAS90\==\
  2. Path to Views DLL: C:\Sage\Sage 100 Standard\MAS90\HOME
  3. Prefix for data files: C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\
  4. Path to Views DLL: C:\Sage\Sage 100\MAS90\HOME
  5. Check Dirty Read:
  6. Check Burst mode:
  7. UnCheck Key Restric:
  8. UnCheck Silent mode:
  9. UnCheck Enforce DOUBLE:
  10. UnCheck NULL Date:
  11. Check Strip trailing spaces:
  12. Cache Size MB:4
ProvideX ODBC
    System DSN
    Options
    Option 2
  1. Prefix for data files: C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\
  2. Path to Views DLL: C:\Sage\Sage 100 Standard\MAS90\HOME
  3. UnCheck Dirty Read:
  4. UnCheck Burst mode:
  5. UnCheck Key Restric:
  6. UnCheck Silent mode:
  7. Check Enforce DOUBLE:
  8. Check NULL Date:
  9. Check Strip trailing spaces:
  10. Cache Size MB:40
ProvideX ODBC
    System DSN
    Debug
  1. Click on Test Connection
  2. Connection succeeded.
    Datasource includes 1398 tables.
ProvideX ODBC
    System DSN
    Debug
  1. Click on Connection String
  2. Results of connection string can be used for provider string ( @provstr= ) in linked server.
  3. Click on OK
ProvideX ODBC
    System DSN
  1. Click on OK
    2. SQL Instance
  2. Restart SQL Instance
Sage ODBC 2022
ProvideX ODBC
    Data Source Administrator
  1. Open ODBC Data Sources (64bit)
  2. Click on Tab System DSN
ProvideX ODBC
    System DSN
  1. Click on Name S100_ABC
  2. Click on button Configure...
ProvideX ODBC
    System DSN
    Basic
  1. Data Source Name: S100_ABC
  2. Description: DataPlus Link Server
  3. Database Directory: C:\Sage\Sage 100 Standard\MAS90
  4. Definition File: Leave Blank
ProvideX ODBC
    System DSN
    Server
  1. Server Name or IP: Leave Blank
  2. TCP/IIP Port: Leave Blank
ProvideX ODBC
    System DSN
    Logon
  1. Company code: YourCompanyCode
  2. Default UserID: YourUserID
  3. Password: YourUserPassword
  4. Session: Leave Blank
ProvideX ODBC
    System DSN
    Options
    Option 1
  1. Prefix for data files: C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\
  2. Path to Views DLL: C:\Sage\Sage 100 Standard\MAS90\HOME
  3. Check Dirty Read:
  4. Check Burst mode:
  5. UnCheck Key Restric:
  6. UnCheck Silent mode:
  7. UnCheck Enforce DOUBLE:
  8. UnCheck NULL Date:
  9. Check Strip trailing spaces:
  10. Cache Size MB:4
ProvideX ODBC
    System DSN
    Options
    Option 2
  1. Prefix for data files: C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\
  2. Path to Views DLL: C:\Sage\Sage 100 Standard\MAS90\HOME
  3. UnCheck Dirty Read:
  4. UnCheck Burst mode:
  5. UnCheck Key Restric:
  6. UnCheck Silent mode:
  7. Check Enforce DOUBLE:
  8. Check NULL Date:
  9. Check Strip trailing spaces:
  10. Cache Size MB:40
ProvideX ODBC
    System DSN
    Debug
  1. Click on Test Connection
  2. Connection succeeded.
    Datasource includes 1398 tables.
ProvideX ODBC
    System DSN
    Debug
  1. Click on Connection String
  2. Results of connection string can be used for provider string ( @provstr= ) in linked server.
  3. Click on OK
ProvideX ODBC
    System DSN
  1. Click on OK
    2. SQL Instance
  2. Restart SQL Instance
Sage ODBC 2019
ProvideX ODBC
    Options
    Time out message
    Resolution 1
  1. Prefix for data files: C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\
  2. Path to Views DLL: C:\Sage\v2019\MAS90\Home\
  3. Check Dirty Read:
  4. Check Burst mode:
  5. UnCheck Key Restric:
  6. UnCheck Silent mode:
  7. UnCheck Enforce DOUBLE:
  8. UnCheck NULL Date:
  9. Check Strip trailing spaces:
  10. Cache Size MB:4
ProvideX ODBC
    Options
    Time out message
    Resolution 2
  1. Prefix for data files: C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\
  2. Path to Views DLL: C:\Sage\v2019\MAS90\Home\
  3. UnCheck Dirty Read:
  4. UnCheck Burst mode:
  5. UnCheck Key Restric:
  6. UnCheck Silent mode:
  7. Check Enforce DOUBLE:
  8. Check NULL Date:
  9. Check Strip trailing spaces:
  10. Cache Size MB:40
Related FAQs
   
Software Solutions
DataPlus Integration
DataPlus ERP Integration
DataPlus Custom Integration
DataPlus Addons
DataPlus Plugins & Tools
Hosting Solutions
Mobile Solutions
QuoteWerks Quoting Solutions
QuoteWerks Integration
QuoteWerks Subscription & Licensing
CRM Solutions
ERP Integration
Custom Integration
Addons
Plugins & Tools
Training
Support
Learning - Support
Software Support
Support (GoToAssist)
Support Plans
Training
Training
KB Hogan Data / DataPlus
KB QuoteWerks Questions
Contact Us
About Us
How Can We Help You
Privacy Policy
Return Policy
Resources
DataPlus Subscription
DataPlus Maintenance
QuoteWerks Maintenance
Partner Lead Submission
Secure CC Authorization
Secure CC Pre-Authorization

Translate this page:
©1995 - 2019 HOGAN DATA | All rights reserved