FormerMember

Data dictionary / Querying Sage 300 with PHP

Posted By FormerMember

Hi, all.

I'm trying to create a couple of simple PHP pages to display some info from CRE 300, using the 32-bit Timberline ODBC driver (not MS SQL).  The ODBC connection works for MS Access and Excel, and I can establish a connection using PHP, but I'm not able to query the tables using PHP.  I think my problem may just be that I don't have the table names correct, and in spite of seeing several posts that say the data dictionary is available in the Knowledge Base, I've not found it yet.

For example, in MS Access, I see a table name of APM_MASTER__VENDOR.  If I display the tables using the PHP odbc_tables() function, I see a table name of MASTER_APM_VENDOR.  A "select *" from either of these yields a "SQL error: [Simba][SimbaEngine ODBC Driver][DRM File Library]No such table or object." error.

I've also seen mention that one can go into Report Designer and get a list of all of the available fields, which will come in handy later, but that still doesn't help with the problem of not knowing what the tables are called.

Any help would be most appreciated.