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…
Employee
Emp Name
Per Begin Date
Period End Date
Fringe ID
Amount
Deduction ID
Amount
1001
Jackson, One
1/4/2021
1/10/2021
MEDEMP
$ 220.00
MED01
$ 95.00
1003
Jackson, Three
1/4/2021
1/10/2021
MEDEMP…
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…
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…
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?
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…
I'm trying to pull records from the PJ Field Reports Labor Table in Crystal but I'm unable to figure out how the employee is being linked. Does anyone know what table is being used to link the employee to the PJ Field Reports Labor table?
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…
I have a custom Crystal Report that I created and when entering the same date parameter on 4 computers, one will show the wrong information.
Example: 09/01/2019 - 09/20/2019 (September 1, 2019 - September 20, 2019) 3 computers bring up the same correct…
Hi,
We're trying to re-write a series of reports that we had in the Paradox version, that delivers info via Excel. We were planning on using a ODBC connection (unless someone can suggest something better).
We're looking for the database account…
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…
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?
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,
I am starting with a base report that uses a "work file" database - let's say Packing List. Can I link to another work file database and expect to get any data from the second work file? I'm thinking NO, since work file style databases are only populated…
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…
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…
Hello. My client uses SAGE 100 ERP. I've been tasked with building a new ETL using VS2017 and SQL 2017 Azure. I need the ODBC drivers for the SAGE DB. How can obtain them? Thanks.
We use ODBC to connect to MS Access for several custom reports we use. After upgrading from Sage 100 Standard ver 2015 to 2017, ODBC connects to most files. However, when we try to connect to the AR Invoice History Header file it will display data correctly…
The current situation :
We are using ODBC to pull data from the Sage 50 database to Excel. For example, if we pull the table taccount from the database we get the table with the GL accounts list and the amount at the present time. It produces a trial…
I am writing out a program and I keep getting this error on my sql statement
Error: Expected lexical element not found: <identifier> (State:37000, Native Code: 3F7)
Here below is my sql statement. I am nesting a select statement.
SELECT ItemCode…
I have inherited a project that requires some querying to a SAGE 100 database. I would like to do this from a PHP script. I have read a number of questions/articles about connecting to SAGE 100 ODBC via PHP and it seems straightforward. However, this…
Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…
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…