Solved ODBC - Phonebook / Contacts

Discussion in '3CX Phone System - General' started by KarstenW, Feb 17, 2017.

Thread Status:
Not open for further replies.
  1. KarstenW

    Joined:
    Aug 9, 2016
    Messages:
    19
    Likes Received:
    2
    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
     
  2. KarstenW

    Joined:
    Aug 9, 2016
    Messages:
    19
    Likes Received:
    2
    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.
     
  3. GiannosC_3CX

    GiannosC_3CX Guest

    Hi KarstenW,

    Glad to hear the issue is resolved and thanks for sharing the solution :)
     
Thread Status:
Not open for further replies.