Solved ODBC Directory search not workin

[sanketgroup]

Hello
I am running v14 sp2.

I was trying to setup MSSQL ODBC directory search.

I set DSN on PC where 3cx is installed.
I used 3cx ODBC connection test tool found on http://www.3cx.com/docs/odbc-search-phonebook-directory/
Tool shows me everything perfect.
And same setting made in 3cx server > Directory Search > ODBC

But no clients are getting search result and just getting regular caller id.

I was monitoring SQL server if any query coming from 3cx. But there was none except query which came from test tool.
Pls help me to solve this.

Thanx

 

[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.