Solved ODBC Directory search not workin

[NickD_3CX]

From what I was told the issue was different in both previous cases. May I suggest you loanword the test tool found in this link and check if everything works?
http://www.3cx.com/docs/odbc-search-phonebook-directory/

Also if you are using MSSQL read the note at the bottom of the article.

 

[wtrbhe]

Hi rodin1,

we had to change the query string
from: "select * from ..."
to: "select <comma-seperatet list of fields> from ..."
After this it worked fine.

 

[iangoh]

DSN name cannot have = sign. This is not fixed in V15.
When will this be fixed? We still have no chance to get this working with MSSQL.
However, like a lot of other users, the test tool works perfectly.

 

[chris.hodel]

We have the same problem with V15.
Test Tool works perfect, but nothing happens.
What kind of bug with the " signs is that?
Any workaround?

 

[Dmitry Kravchenko]

I have same problem, but can' use SELECT to get data. I use stored procedure: EXEC dbo.FindNumber @Number='%%number%'
14v worked perfect, but after 15 no data at ODBC trace, SQL profiler and 3CX log show all is good:
2017/06/08 15:09:36.472|2532|0019|Info|No result found in SQL for number: 85249101010, so search in LDAP
Test Tool working correctly.

My settings:


Help pls.