I have a problem with the ODBC integration.

[adem kılıç]

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.

 

[cloidhamer]

If you are querying a MS SQL db then I think you are missing the database in your DSN Name.
<DSNName>;UID=<UserID>;PWD=<Password>;database=<DBName>