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