Jade ODBC Office 365 issues
Posted: Fri Sep 14, 2018 3:33 pm
Hello everyone,
I am using Greentree ERP that is based on Jade DB and having issues connecting Excel and Power BI to the database via ODBC. I will try to explain it as good as i can.
Whenever i use ODBC connection then go to load one of the tables (even as small as 6 rows) it just sits there trying to load for a few minutes and then fails.
However if i add SQL code in 'Advanced' field Excel seems to grab data if table is not very big.
Example of code
SELECT
companyCode,
oid
FROM LoginSchema.HRControl;
Can anyone assist with this issue?
I am using Greentree ERP that is based on Jade DB and having issues connecting Excel and Power BI to the database via ODBC. I will try to explain it as good as i can.
Whenever i use ODBC connection then go to load one of the tables (even as small as 6 rows) it just sits there trying to load for a few minutes and then fails.
However if i add SQL code in 'Advanced' field Excel seems to grab data if table is not very big.
Example of code
SELECT
companyCode,
oid
FROM LoginSchema.HRControl;
Can anyone assist with this issue?