x Want to participate? Join the group to interact

  • 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…

  • No longer able to Import Data into Excel

    Across our network users have previously been able to run the data query as explained in the Sage article https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=51308&sliceId=1&noCount=true&isLoadPublishedVer=&docType=kc&docTypeID…

  • Subqueries supported?

    I am trying to use subqueries and joins in my PHP script that is pulling data from SAGE, but I keep getting this error: Warning : odbc_exec(): SQL error: [ProvideX][ODBC Driver]Expected lexical element not found: <identifier> Here is my query: SELECT…

  • 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…

  • RE: General ODBC Errors (Pass Through Queries) in Access 2016

    Update to this, might be helpful to others. Uninstalling Microsoft Office Update KB3115501 solves the issue (at least for Office 2016). This update, according to MS website, is supposed to allow import and export date to dBase. Hoping MS resolves the…

  • General ODBC Errors (Pass Through Queries) in Access 2016

    Hi all; I've been having some serious difficulty finding an answer to this issue, which has led me to create my first post here. I have an access database that pulls tables from all companies by use of pass through queries. Connection strings are handled…

  • sData Query - URL format

    Hi There - I don't know if this group is still active, I'm having trouble trying to query resources by date. For instance, using this query to get sales orders: mydomain.com/.../*** /SO_SalesOrderHeader The query parameters I've tried: …

  • Custom Queries From My Application

    I built an application that pulls data from BusinessWorks, which now needs to be converted to Sage 100 4.5. With BusinessWorks, I ran simple queries like the following against the ODBC connection with no issues. With Sage 100, I'm receiving an error:…

*Community Hub is the new name for Sage City