Re: Fwd: Error using odbc 11.00.0000 - Mailing list pgsql-odbc

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

ウイルス フリー｡ www.avg.com