I am trying to automate archiving of the Log files generated by sage.  We generate an average of 15,000 log entries a day and the LogViewer in sage is so slow it is nearly unusable after a month.  I am querying the data older than seven days and then inserting it to our SQL Server.  Using the same connection string I can query data from the QLM Master Log but when I go to delete data I get an error.

With my Sage user service account:

ERROR [42000] [Simba][SimbaEngine ODBC Driver][DRM File Library]Access denied.

With my personal Sage user account.  I was failing at opening second connection with this error: (Still not sure why but not directly relevent)

ERROR [08001] [Simba][SimbaEngine ODBC Driver][DRM File Library]Invalid account name.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

Once i adjusted my code to no longer attempt a second connection open I get the same error:

ERROR [42000] [Simba][SimbaEngine ODBC Driver][DRM File Library]Access denied.

Any help would be appreciated.  Specifically what access is required by the sage account to run my delete command?