Sage 100

 View Only

  • 1.  Database Login on one workstation

    Posted 12-12-2019 08:45
      |   view attached
    Running Sage 100 2018 Advanced.  On one workstation we cannot run any Crystal Reports.  We get the attached database log in. I've removed the ODBC, uninstalled, reinstalled and rebooted without resolution.  Any other ideas?  Windows 10 PC

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------


  • 2.  RE: Database Login on one workstation

    Posted 12-12-2019 09:04
    John,

    I would check to see if it's computer related or user related... 

    (Please excuse if you've already seen this).

    Resolution
    <content>
    1. Uninstall Workstation Setup
    2. Remove the C:\Program Files (86)\Common Files\Sage\Common Components directory left behind (leave this directory alone if doing this at the Server)
    3. Reinstall Workstation Setup
    4. If using CS/ODBC features to increase Printing speed verify the following via Windows Services on the Server where Sage is installed
      1. Verify the account running the Sage 100 Client Server ODBC Driver service is a Full permissions user. Note: If running with Local System account make sure the SYSTEM account has FULL SHARE and NT (Security) permissions to be starting the Service
      2. Verify the service is running
    5. If CS/ODBC may have been turned on in Sage but not at the server by accident do the following to turn off
      1. Open Library Master, Setup, System Configuration
      2. Click on the ODBC Driver tab
      3. Uncheck Enable for All Users
      4. Uncheck Enable CS/ODBC Driver
      5. Accept and exit
    6. Open Library Master, Main, User Maintenance
    7. Select first user and click on Preferences tab
    8. Uncheck Enable CS/ODBC Driver
    9. Accept and exit
    10. Test printing now

    Note: on occasion, you may need to do the following between the Workstation uninstall and the Workstation re-install:

    • Rename the pvxio.dll and pvxodbc.dll files in \windows\system32 and \windows\syswow64

    Verify old Providex ODBC driver (v.4.21) is not installed

    1. Go to Start, Control Panel, Program and Features
    2. Look for 'Providex ODBC Driver (v.4.21)'
      Note: Search for and rename and versions of 'PVXIO.dll' under the 'C:\Program Files (x86)\Sage Software\Providex ODBC Driver\' folder. Test printing from Sage 100, to verify this was the cause of the issue.
    3. If no longer using Uninstall 'Providex ODBC Driver (v.4.21)'

    </content>

    Related resources
    "The following error occurred while connecting to the SQL server: S0000: [ProvideX][ODBC Driver][PVKIO] Version Conflict between the driver and low level I/O routines (pvxio.dll)" when printing Crystal Forms"
    How to install and configure the Client/Server ODBC driver for Sage 100 Advanced version 2013 and higher
    How to install Workstation Setup for Sage 100
    What are the required permissions for Sage 100 ERP?
    Category
    Data and database
    ODBC



    ID:57706Last Modified Date:9-25-20191569445599603   ​

    ------------------------------
    Roberta Chase
    Enterprise Software Consultant--Sage 100, Crystal Reports, Sage Intelligence, FAS, Starship
    CompuData, Inc.
    Philadelphia, PA 19154
    215-969-1000, ext. 277
    ------------------------------



  • 3.  RE: Database Login on one workstation

    Posted 12-12-2019 09:09
    My copy and paste missed the beginning of the above message.  Here's the beginning of it:

    Description
    <content>

    A Database Login prompt window for Crystal Reports appears when printing or previewing a form or report in Sage 100; user is prompted to log in

    The user is prompted for Login ID and Password. The Server Name and Database fields also appear (disabled)

    </content>
    Cause
    <content>

    • The SOTAMAS90 DSN may be damaged or missing for the Workstation client
    • Workstation software Crystal Runtimes are damaged
    • The Windows account running the CS/ODBC Driver service, if being used, does not have FULL SHARE and NT Permissions under Sage 100 ERP Share
    • CS/ODBC Service has been turned on in System Configuration but Sage server has not be configured to use the service or it does not exist
    </content>

    ------------------------------
    Roberta Chase
    Enterprise Software Consultant--Sage 100, Crystal Reports, Sage Intelligence, FAS, Starship
    CompuData, Inc.
    Philadelphia, PA 19154
    215-969-1000, ext. 277
    ------------------------------

    Original Message


Related Content