Any help is greatly appreciated.
Using Sage 100cloud Standard.
My company uses Access to query Sage data. This works well, but I'd like to run more advanced and rapid queries. My system administrator has allowed me to install Postgresql on my computer, as a sort of trial. I have been able to import Access tables into pgAdmin, and I've created a few queries there that I would very much like to implement into the company's daily operations. I've created a pass-through query in Access from Postgresql that works well. Problem is, I am having great trouble reaching the Sage data in postgresql. I have the odbc_fdw extension. The settings, I believe, are correct: connecting to the 64-bit MAS driver with Postgresql 13. But I have been trying to run a very simple query, just to get this up and running. I'm trying:
SELECT ci_item
FROM ci_item
LIMIT 5;
This crashes the postgresql server and spawns the error:
LOG: server process (PID XXXX) was terminated by exception 0xC0000005
DETAIL: Failed process was running: SELECT ci_item
FROM ci_item
LIMIT 5;
HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
I've done some research on this issue. I have run memory diagnostics and inspected the hardware: all that seems to be fine. My guess is that this has to do with some kind of permission error vis a vis Sage. One thought I had: could the fact that Sage runs on a file server and Postgresql only runs on a local machine impact communication between the two?
Also, I do not have administrator privileges in Sage, but it seems to me that with my Sage login and password I should still be able to access in Postgresql the data I'm able to access when I run Sage itself.
Does anyone have experience querying Sage data with Postgresql? Again, any help would be much appreciated. Thanks.