Errors connecting Advanced PBX Data Logger to MSSQL Server 2005

[jkeegan123]

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!

[Arthur Grasin]

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.