• Office365 Excel Build 2403 removes MS Query - How to add back

    Just a PSA- Had a customer who users MS Query extensively reach out today to tell me that it seemed that the MS Query function seemed to have been removed. Fortunately it's racy to add it back. Open Excel, select "File" from the toolbar, then "Options…
  • Sage 100 2022 Premium Crystal Reports Database Login Failed. Unable to connect: Incorrect log on parameters

    Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…
  • CS ODBC service stopping after upgrading to v2023

    Upgraded from Sage 100 v2020 to v2023.1 - We are still on the 32 bit version of Sage. Uninstalled old CSODBC service and Installed it again from the v2023 directory. 3 times today the CSODBC service has hung up and needed to be restarted. Here is…
  • "[ProvideX][ODBC Driver] Internal Error"

    This is happening with a single table MS Query in Excel 64-Bit when accessing large individual I/M and P/R files and continues after rebuilding them (Ex. IM_ItemTransactionHistory) . I reviewed the other thread on this error, but nothing applies other…
  • ProvideX ODBC - Data type conversion?

    I have been attempting to simply change the data type of a column for a query I am running through the ProvideX ODBC but I keep getting errors, and I am wondering if this scalar function is not available here. Simply, I am trying to query the IM_PeriodPostingHistory…
  • VI Import Job Unable to open [wdx][odb]<dsn_name>

    I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…
  • 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…
  • SOTAMAS90 ODBC Driver extremely slow to update excel query

    I have an excel spreadsheet that uses the SOTAMAS90 ODBC 64 Bit System DSN to update some data from our AP tables. When I open this spreadsheet on the server with Sage 100 advanced installed the query completes and data is updated is less than 5 seconds…
  • 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…
  • Connection to Sage Data with postgresql fails

    Any help is greatly appreciated. Using Sage 100cloud Standard. My company uses Access to query Sage data. This works well, but I'd like to run more advanced and rapid queries. My system administrator has allowed me to install Postgresql on my computer…
  • Intermittent "[ProvideX][ODBC Driver]Internal error"

    I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…
  • PHP ODBC Connection not pulling results

    I'm new to Sage and ODBC connections in general, so I'm looking for a bit of help here. I have set up a System DSN on the server, and am able to get a successful connection using PHP. However, whenever I try to run any sort of query, it doesn't pull any…
  • Connection String to Silent ODBC DSN using ProvideX ODBC Driver is forcing connection to default to SOTAMAS90 DSN

    We are querying invoice data to read from MAS using the ProvideX ODBC driver from within a custom application. Within the custom application, we have tried specifying credentials explicitly within the connection string used to open the ODBC connection…
  • Sage ODBC with Sage 100 V2020

    I am upgrading a client to Sage 100 V2020 and am running into issues with some Excel spreadsheets that have been working for years in prior versions of Sage 100. In V2020 the client upgraded their Excel version from 2013 to Excel 365 Enterprise 64 bit…
  • SOTAMAS 90 & Power Pivot Error

    Probably a long shot here but whilst trying to import Sage data tables into the Power Pivot table wizard i get the following error: 'Object reference not set to an instance of an object' Any thoughts?
  • SQL Data Warehouse from Sage 100 2018 ProvideX tables

    I have set up a linked server in SQL 2017 set up from Sage 100 using the v4.40.0004 ProvideX ODBC Driver. We are looking to create a data warehouse to mirror Sage 100 ProvideX tables in full and refresh deltas throughout the day. Pulling FULL tables…
  • linked server "SAGE" returned message "[ProvideX][ODBC Driver]Expected lexical element not found: <identifier>".

    I have this query returning the error message. Any idea? SELECT A.SalesOrderNo, B.UDF_COMPLETE_PART, B.UDF_CUST_PART, E.ExtendedDescriptionText, B.UDF_Serial, A.CustomerPONo, A.UDF_EXT_CUST_PO, A.ARDivisionNo, D.CustomerNo, D.CustomerName, A.ConfirmTo…
  • 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?
  • Cannot get an Excel query to return updated information

    Using Sage 100 ERP v2017. I am trying to run a very basic MS Excel query in order to build a database for our new website. Literally, all I am trying to get is the product part number, description and the name of the item image. My query is as follows…
  • ODBC Connection for Power BI

    I have a client that wants to create a dashboard using Power BI, but not with Sage Intelligence. Has anyone created an ODBC connection for use with Power BI? If so, can you outline what you did? Thanks,
  • Access 2016 ODBC / Sage Issue

    Hello. We are having a bizarre issue with Microsoft Office 2016 and an ODBC connection to Sage 100 Advanced 2018 ERP. We use a system DSN to connect to Sage from Access to run queries and reports not available in Sage and have been doing this for years…
  • How do I use crystal reports for sage to connect with sage Premium 100 so I can create my own reports?

    We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…