Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

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:
    3
    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:
    3
    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.