Stack Overflow
Stack Overflow

Questions tagged [sage-erp]

Sage enterprise and accounting software

Sage enterprise solutions http://na.sage.com/us/erp has a large suite of software including many database solutions. Sage city http://sagecity.na.sage.com/ is a good place for questions as well.

104 questions
1
vote
1 answer

Pulling data from an existing database

I am trying to create a web app that handles account data and prints said data to account statements and age analysis. The data will need to be fetched from an existing Sage Evolution database and printed to a web page through Django. I have had a…
KyleStranger
  • 233
  • 3
  • 20
1
vote
2 answers

Add a WHERE clause to a JOIN with an argument in a 3rd table

I'm working on a program to transform DATA from a SQL Server Express database to .CSV files, I'm using C#. I'm facing issues with SQL queries. I need to use a specific criteria to reduce query's range, but this criteria is in another table, called…
Thomas Lefloch
  • 33
  • 7
1
vote
1 answer

C#, MAS-90, Attempted to read or write protected memory error on OdbcDataAdapter.Fill(dataTable)

I am writing a Windows Forms application that needs to query 2 fields from a MAS-90 database. For this we use the MAS 90 32-bit ODBC Driver by ProvideX called SOTAMAS90. Here is the code I use to retrieve a DataTable from the MAS-90…
Smitty-Werben-Jager-Manjenson
  • 480
  • 5
  • 16
1
vote
1 answer

sData REST APIs for sage 100 ERP

I have a business partner account. And, I have setup sage SData and Sage ERP 100 on window server machine. I can access some resources in the browser like: https://sage.lvh.me/SData/MasApp/MasContract/ABX/AR_Customer It returns a huge file of…
Sarwan Kumar
  • 1,283
  • 9
  • 24
1
vote
1 answer

Sage200c SDK crashing in webforms

We are having a problem with the Sage 200c Extra 2018 SDK when used in Web Forms. We have created solution with library, win forms and web forms project. We have noticed that when using the 'Win Forms project' it works, but the same example in 'Web…
AltF4_
  • 2,312
  • 5
  • 36
  • 56
1
vote
0 answers

Cannot cast the underlying exported value of type

I have a project that is attempting to connect to Sage 200. However it is complaining that the type initialisation has failed now usually that is to do with assembly not being in the cache however this time it is. I have restarted, The error that I…
David B
  • 315
  • 3
  • 13
1
vote
1 answer

How to create account with read-only access to a Sage ERP database for use with pyodbc

I'm a relatively new user at StackOverflow, so my apologies if I violated any rules in my post. Here's some quick background to set the context for my question. I work as a quality analyst for a manufacturing company that stores all pertinent…
Campbell D
  • 95
  • 1
  • 2
  • 10
1
vote
1 answer

Connect to SAGE 100 with PHP

I want to ask if it is possible to connect to SAGE with PHP, using odbc(SAGE Gestion commerciale 100)? I've succeeded to connect only with MS Query (MS Excel).
donia
  • 29
  • 3
1
vote
0 answers

How to connect website to sage 50

I have been researching about integrating sage 50 to a website. The odbc connection is working if I'm on localhost but it's not working on production. Please confirm what should I check or missing? I am using PHP to connect it. It always fails…
Donna
  • 133
  • 1
  • 1
  • 5
1
vote
2 answers

Trouble connecting to Sage 50 with Excel via ODBC

I'm trying to get into Sage 50 (v20 2014) via ODBC in Excel 2016 64bit. I keep running into connection problems. I've set up a 64bit DSN using the utility on the Sage disk and I get the following... If I go through 'Data/From other sources/From…
dazzathedrummer
  • 511
  • 2
  • 10
  • 26
1
vote
1 answer

Can you connect directly with an "ODBC data source" using Java?

I am tasked with integrating a certain program, Sage 50 / PeachTree, with a third party program. I need to get data from Sage 50 and transfer it to the other program on a regular schedule. Sage 50 only has a .NET API and the third party program has…
user4984149
1
vote
1 answer

Sage 200 database

I've noticed that in many Sage 200 databases, looking at the sales side, there aren't enough allocations to make up the allocated value recorded for some rows in the table SLPostedCustomerTran. In other words, the following query returns a non-zero…
Klitos Kyriacou
  • 10,634
  • 2
  • 38
  • 70
1
vote
0 answers

Specified driver could not be loaded due to system error 8: Not enough storage is available to process this command

I've been having trouble with this error for a few day now. SQL Exception: Specified driver could not be loaded due to system error 8: Not enough storage is available to process this command. (Sage Line 50 v20,…
Laurence Nicolaou
  • 569
  • 2
  • 8
  • 28
1
vote
3 answers

Microsoft Access Like/Not Like

I seem to be having issues with MS Access in the following query based on a SAGE database The following code does not work - it doesn't like the "NOT like" part SELECT tran_number, Inv_ref, Details, date, Net_amount, amount_paid FROM…
Owen Partridge
  • 63
  • 2
  • 9
1
vote
0 answers

Error appears in Accpac integration

I'm trying to do an integration between sage 7.0 and 5.5 and when i try to open a session i get an error Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) I tried every solution online the target machine is set to…
SahemS
  • 11
  • 1
1
2
3 4 5 6 7