x Want to participate? Join the group to interact

  • ODBC Error when SSIS package is run from SQL Job - Sage 2022

    Hi All. We're in the process of upgrading to Sage 2022 and I'm trying to recreate some SSIS packages (SQL Server 2019 and Visual Studio 2022) that connect to Sage 2022 via the ODBC 64-bit driver and copies to one of our SQL Server 2019 tables. I'm…

  • ODBC Driver ADO NET Connection (COMPLUS Error)

    In our SQL Agent Data Warehouse load job, we are running into intermittent issues with connecting to our ODBC driver. We had run into this issue previously, but it essentially disappeared on its own; however, once I upgraded the SQL server's OS to Windows…

  • Adding ODBC connection in Power BI service fails; works locally

    Greetings, I'm running into a roadblock attempting to add an ODBC data source via Power BI Service via +New / Data sources page from the following URL. https://app.powerbi.com/groups/me/gateways Here are a few facts: The ODBC driver (for Sage…

  • How to share a silent ODBC Connection

    I've connected a single table from Sage 100c 2021 to Excel (data model) via a silent ODBC connection with saved username/password. All works great for me, but if anyone else uses this excel workbook and tries to refresh the data it makes them log in a…

  • Excel File using ODBC created by one user. 2nd user gets error when trying to update

    User 1 created an excel file that pulls in data from Sage 100 Standard via ODBC. Created same dsn connection (same dsn name) on User 2's computer. "Test Connection" successful with saved username/pw. User 2 opens the same excel file and tried to refresh…

  • ODBC - Is ODBC security within Role Mainnance REQUIRED?

    If we currently do NOT have ODBC Security within Role Maintenance enabled , what are the abilities/restrictions of users to create an ODBC data source connection?

  • ProvideX ODBC Issue

    I am writing out a program and I keep getting this error on my sql statement Error: Expected lexical element not found: <identifier> (State:37000, Native Code: 3F7) Here below is my sql statement. I am nesting a select statement. SELECT ItemCode…

  • Using 64-bit ODBC with 64-bit Excel - Unable to access view tables

    We have a customer that uses view tables created to optimize queries run in MS Query. These queries run in 32-bit ODBC and 32-bit Excel, but do not run with the 64-bit versions of the same. All other tables aside from view tables are able to be accessed…

  • SSIS Package Providex Occasional Extract Issue

    We use SSIS to grab all the information from MAS for use in reporting. We use the ODBC driver to do this. This works with no issues the majority of the time. Occasionally, but still often enough, there will be an issue with the extraction, causing…

*Community Hub is the new name for Sage City