Fwd: Error using odbc 11.00.0000
Walter Willmertinger <[email protected]> Tue, 20 Nov 2018 15:21:34 +0100
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <CAHbMG0XKvxJZwVX=qvX5zSNARjo+sZSVd1BSzkLaRPXwNkz9+Q@mail.gmail.com> |
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