Re: Fwd: Error using odbc 11.00.0000

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