Browse By Tags

  • 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…
  • Sage 300 2022 - What ODBC we need or must use to setup companies/system ODBC?

    Hi everyone, I have some customers with Sage 300 2022 and they have and use to setup ODBs for companies/sytem SQL Server Native Client 11.0. But with a customer we are upgrading to that same Sage 300 2022 version, and we dont found it. We download…
  • 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…
  • Sage 200 OBDC adding in Delivery Addresses

    Hi, I have the below code but need to add in the the delivery postcode (highlighted yellow below) - how would I add this in, I'm not to sure of the joins? SELECT DocumentNo, DocumentDate, DocumentTypeID, DocumentStatusID, SOPOrderReturnLine.ItemCode…
  • Default ODBC Driver Incompatible with Server OS Version

    We have a new Windows Server 2019 and SQL Server 2019 for our Sage 500 upgrade to version 2021. We use Sage via RDP. The Client is not installed on user PCs. They RDP to the server which is configured to launch a Sage session for the user. Sage is working…
  • [X3v12p33] In X3 Console, for SQL AG cluster setup and Amazon FSx Application Server, during folder import, received `The wait operation timed out.`

    Hi, Context: Sage X3: v12 Patch 33 Application folder (symbolic link): C:\ -> UNC Path at Amazon FSx DB: SQL Server 2019 Std. DB Cluster: Active/Passive Availability Group (AG). Using AG listener name and port. Followed: https://www.sagecity…
  • ODBC Connections and Intergrations with Business Works

    Hi, We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations. We have a few questions: Can we use SQL to set up an ODBC connection? …
  • 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…
  • Sage 300 - Database is locked

    Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
  • [AWS RDS] X3 Console - ODBC install path

    Context: - X3 Console's Database setup: Manual configuration. - At AWS RDS, no install of AdxAdmin and SQLComponent. From the manual configuration screen, it ask me this. For the bottom 2 fields, how do I fill them up when I have no details…
  • Sage 50 CA Quantum accounting 2023 ODBC Driver missing

    Hello, we are using Sage 50 CA Quantum accounting 2023 (version 30) in our company, and we would like to build a bi-dashboard using Tableau or Power BI with our data. The Sage installation for this version does not include the Sage ODBC driver on our…
  • 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…
  • ODBC connection after upgrade to 22.2

    I have a bunch of excel files that ready from different AP, AR, JC etc tables using a User DSN with the Timberline Data driver. Prior to upgrading today, they all worked. Since the upgrade, I'm getting an error that the "required credential settings are…
  • Query for Logged In Users?

    One of our users runs a script in the evening to modify data. Once in awhile, they will receive an error that data is locked by user. I know that we can kick users by going into Help > Current Users, but I was wondering if there is a table containing…
  • 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…
  • Accessing Sage 300 ODBC via powershell [Sage][SQLEngine] (31830) Username and password is required.

    I am trying to establish a ODBC connection to Sage 300 using Powershell ODBC. I am getting below error. I have tried using the same username and password for importing via ODBC in MS Access and it works. What am I missing? Exception calling "Open…
  • I can't establish a connection via ODBC

    Hello Colleagues, I have a problem connecting to Sage 50 from ODBC, when I try to connect to the database from excel or another program it does not validate my credentials. I have done all the processes in the documentation, I enabled the permissions…
  • 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…