Error using odbc 11.00.0000

After installation of this new release we have follwoing problem in an MS
ACCESS project.
In a form there is a search window where a user can enter a search string.
The data source for this form is following query:

SELECT Interessenten.[ID]
FROM Interessenten
WHERE ((([Name] & ',' & [Vorname]) Like '*Ritter*')) OR
(((Interessenten.Ort) Like '*müller*')) OR (((Interessenten.PLZ) Like
'*müller*')) OR (((Interessenten.Handy) Like '*müller*'));

This query leads to an exception:
ODBC Call failed (in german)
ERROR: function concat(text,text) does not exist:
Error while exection the query(#1)

If I omit the concatenation: ([Name] & ',' & [Vorname]) Like '*Ritter*'),
the query is executed normally.

Environment: ODBC 64 Bit, Windows 10, Access 2013
I already activated

Regards

Walter Willmertinger

Hi Walter,

What is the PostgreSQL server's version?

regards,
Hiroshi Inoue

On 2018/11/20 23:21, Walter Willmertinger wrote:

After installation of this new release we have follwoing problem in an
MS ACCESS project.
In a form there is a search window where a user can enter a search string.
The data source for this form is following query:

SELECT Interessenten.[ID]
FROM Interessenten
WHERE ((([Name] & ',' & [Vorname]) Like '*Ritter*')) OR
(((Interessenten.Ort) Like '*müller*')) OR (((Interessenten.PLZ) Like
'*müller*')) OR (((Interessenten.Handy) Like '*müller*'));

This query leads to an exception:
   ODBC Call failed (in german)
   ERROR: function concat(text,text) does not exist:
   Error while exection the query(#1)

If I omit the concatenation: ([Name] & ',' & [Vorname]) Like
'*Ritter*'), the query is executed normally.

Environment: ODBC 64 Bit, Windows 10, Access 2013
I already activated

Regards

Walter Willmertinger

---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com