Solved ODBC - Phonebook / Contacts

[KarstenW]

Hello,

I have a problem with the ODBC integration.

The CDM_ODBC_Test Tool works fine and I get correct results.
The trace of ODBC works with Test Tool too, but does not log anything for 3CX.

It´s a 3CX v15 Server

Tested config:

3cxpb;uid=tesname;pwd=testpw

SELECT firstname,lastname,phone,mobile FROM T_T3CX where mobile like '%%number%' or phone like '%%number%'

and

SELECT * FROM T_T3CX where mobile like '%%number%' or phone like '%%number%'​

With and without "Check this option to prefer ODBC over LDAP"

Please help me, this feature is very important to us.

Kind regards
KarstenW

 

[KarstenW]

I got a solution, I had to change the IDs starting from 0. I don´t know why, because 0 is the identifier of the db table, but it works now.

 

[GiannosC_3CX]

Hi KarstenW,

Glad to hear the issue is resolved and thanks for sharing the solution