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!
Did you create a database table? If yes, then you should
1. Go to the "ODBC plugin" - "Binding" page.
2. Import your table description.
3. Bind parser items with columns
Also you may reinstall the software over the installed version and select "Write data to a database" option. In this case the installation wizard will create the database table and all corresponding settings automatically.
If you don't want to reinstall the software, then you may find a database table structure in "Program folder\Data\MSSQL.sql". You should execute this script in your database. Then load the MSSQL preset within the ODBC plugin.