Beginner SAGE 100 ODBC Questions

SOLVED

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 is my first time working with anything SAGE, or any software like it. I don't know what the name of my datasource is, or where to find it. I figure one place to try is Library Master -> Setup -> System Configuration, but the ODBC Driver tab is unresponsive. It is not grayed out, it is just unresponsive. Granted this is a "Driver" tab, maybe it's not even what I am looking for.

I hope I don't appear to be too in over my head. But if any veterans can help me figure out what my datasource name is so I can at least move on to my next problem, I'd be very appreciative!

Steven

Parents
  • +1
    verified answer

    That ODBC tab is only enabled for Advanced (for use with a CS-ODBC service to speed report performance from workstations), so I assume you're on Standard or Premium.  If Premium, go directly to SQL.  If Standard, log into Sage 100 once with the Windows ID you're using, then look in the 32-bit ODBC utility for SOTAMAS90 (user DSN).  Use this information to create a system silent DSN (...there are instructions available for this in a few places).

Reply
  • +1
    verified answer

    That ODBC tab is only enabled for Advanced (for use with a CS-ODBC service to speed report performance from workstations), so I assume you're on Standard or Premium.  If Premium, go directly to SQL.  If Standard, log into Sage 100 once with the Windows ID you're using, then look in the 32-bit ODBC utility for SOTAMAS90 (user DSN).  Use this information to create a system silent DSN (...there are instructions available for this in a few places).

Children