The service needs to run as a user that has the proper select access to the database.
Open the Services Management Console
Start -> Run -> services.msc
Double click on the service TNGOCSInterface and click on the second tab "Log On".
On this screen enter the login details of the user that has the correct access to the database.
In the folder that contains the service, the ADO file must contain the database connection details.
- Code: Select all
C:\program Files\Datatex\TNG_OCS\
The ADO File looks like this
- Code: Select all
;Place your server name here, but leave the Database as is, if it is a default created database.
Driver={SQL Native Client};Server=sapserver;Database=LcsCDR;Trusted_Connection=yes
Once the service connects it will start to retrieve records from the database and processing them for TNG.
The service will write the last successful ID processed to it's INI file. Then when it starts up again, it continues to retrieve call recordings from the las ID processed.
If the Database is manipulated to reset the ID's or if a blank database is used, the Next ID in the INI file should also be reset to the first ID in the database.
The section in the INI file looks like this:
- Code: Select all
[GENERAL]
;This is the next ID that will be retrieved from the Database.
DATA_NEXTID=14339
;This is the timezone adjustment.
TIMEZONE=2
Change the DATA_NEXTID=0 to start retrieving all the data from the start of the database again.