• 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…
  • 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…
  • Are there any plans whatsoever for 64-bit ODBC drivers?

    Many of us are not using SQL replicator as the hardware requirements are up there, server and client, and we have enough data that I believe we would need full SQL vs express. Especially if your accounting dept wants the data to be live.(which ours does…
  • How do I get information from imported HH2 hours?

    We set up SQL replication last week and it is working well. However I am having trouble finding where our HH2 imports actually end up in the SQL database. We import a HH2 payroll each week via the import tool in Payroll > Tools > Import Time... Where…
  • Accessing Sage 300 CRE Data from the Web - Error [28000][Sage][SQL Engine](31830)Username and Password is required

    We are accessing Sage 300 CRE data in a web page using the ODBC 32 bit driver we set up as a system dnn (TMBWeb). The dsn points to the correct data folder and is configured for standard descriptions and maximum table segment size. We have a connection…
  • Any way to empty Sage 300 CRE log file?

    In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…
  • Table and Field Naming mode - JDBC2Pervasive query

    I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB. In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db. Class name is: com.pervasive.jdbc.v2.Driver. URL is in…
  • Connecting Crystal Reports 2016 to Sage 100 Contractor v20.5

    FormerMember
    FormerMember
    I'm trying to connect Crystal Reports 2012 to Sage 100 Contractor v20.5 via an ODBC connection. I have created the ODBC connection successfully by allowing access from other applications (DAT->Advanced Settings...->Advanced SQL Server Settings->Edit Approval…
  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…
  • Problem: ODBC Syntax error when referencing Check column of table APM_MASTER__INVOICE_PAYMENT.Check

    Problem: ODBC Syntax error when referencing Check column of table APM_MASTER__INVOICE_PAYMENT.Check, while other columns respond as expected Background 32-bit ODBC driver – installed OK Sage Role/user verified – OK DSN – User DSN and System…
  • ODBC Error when attempting DELETE query

    I am trying to automate archiving of the Log files generated by sage. We generate an average of 15,000 log entries a day and the LogViewer in sage is so slow it is nearly unusable after a month. I am querying the data older than seven days and then inserting…
  • ASP.NET MVC to Timberline connection

    I am having trouble connecting to timberline from my asp.net mvc 4 application. MY CODE String connection = "DSN=Timberline Data Source;Uid=<myusername>;Pwd=<mypassword>;"; OdbcConnection timberlineConnection = new OdbcConnection(connection); timberlineConnection…
  • Slow ODBC Queries

    Hello All, I have a problem I have been researching lately regarding slow queries over ODBC to our sage server. I have seen people with similar issues on other sites, but no real solutions.... We have a web server that uses PHP to query several database…