I am trying to connect the Advanced PBX data logger to an Allworx PBX.
I have successfully connected to the Allworx PBX and calls are logged. However, when I try to configure the output to be dropping data into my SQL server (using SQL authentication), I get: Error while accessing database [No SQL statement available]. This is when I configure through ODBC. I have already configured the ODBC entry and tested access successfully using SQL authentication.
If I try to connect to SQL directly (not using ODBC), I get: Data have been processed with errors.
In both cases, the database setup is successful. I have also specified the database during PBX Logger installation, with SQL username and password, and the SETUP program creates the initial tables without issue.
If I am going to purchase this program, I am going to be purchasing a LOT of licenses, and I need this working without issue. Can Someone help me, or give me a # that I can call?
I am logging calls correctly, just just to the database. I have no issue with my SQL server or my ODBC entry as both check out correctly. Please help!