: Pablo Sánchez [mailto:pab...@adinet.com.uy]
Gesendet: Donnerstag, 13. Oktober 2016 14:53
An: firebird-odbc-devel@lists.sourceforge.net
Betreff: Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and
Crystal Reports 2016
I guess you can check the odbc config for quoted identifier or
And the error
is on this line:
FROM ((("
"."AuswahlLehrer" "AuswahlLehrer" LEFT OUTER JOIN "
"."Lehrer" "Lehrer" ON
It doesn’t want
the dot, or this kind
er"."Dienstbez"="Dienstbez"."Kuerzel") LEFT
OUTER JOIN " "."Konfessionen" "Konfessionen" ON
"Lehrer"."Konfession"="Konfessionen"."Kuerzel"
WHERE "Lehrer"."Status"=1
ORDER B
An: firebird-odbc-devel@lists.sourceforge.net
Betreff: Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and
Crystal Reports 2016
12.10.2016 16:04, Antonio Cambule (STÜBER SYSTEMS) wrote:
> Any idea if this can be solved?
Turn on server-side trace and see what is the real query af
Antonio, does this query runs on isql or any db manager ?
Take the odbc stuff out of it (like opening "{oj " and closing "}" )
and try a run .
I see that the query, is shorter than 1165 chars
Regards
Pablo
On 10/12/2016 11:04 AM,
12.10.2016 16:04, Antonio Cambule (STÜBER SYSTEMS) wrote:
> Any idea if this can be solved?
Turn on server-side trace and see what is the real query after ODBC driver
transformed
ODBC join into ANSI join. Avoid mixing of these types of joins in one query.
--
WBR, SD.
--
Hello,
When it comes to execute a crystal reports file in the -most cases- (not all)
this error is thrown:
Fehler beim Öffnen eines Rowsets. (english: Error opening rowset)
Details: HY000:[ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unkown - line 1, column 1165
.