• V20: 3CX Re-engineered. Get V20 for increased security, better call management, a new admin console and Windows softphone. Learn More.

Solved ODBC - Phonebook / Contacts

Status
Not open for further replies.

KarstenW

Free User
Advanced Certified
Joined
Aug 9, 2016
Messages
22
Reaction score
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
 
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.
 
Hi KarstenW,

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

Getting Started - Admin

Latest Posts

Forum statistics

Threads
141,620
Messages
748,856
Members
144,732
Latest member
Mendy E
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.