Обсуждение: Fwd: Error using odbc 11.00.0000

Поиск
Список
Период
Сортировка

Fwd: Error using odbc 11.00.0000

От
Walter Willmertinger
Дата:
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

Re: Fwd: Error using odbc 11.00.0000

От
"Inoue, Hiroshi"
Дата:
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

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