Menu
▾
▴
Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016
|
From: Pablo S. <pa...@ad...> - 2016-10-13 12:53:26
|
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I guess you can check the odbc config for quoted identifier or
autoquoted identifier.<br>
<br>
Regards<br>
<br>
Pablo<br>
<br>
<div class="moz-cite-prefix">On 10/13/2016 05:10 AM, Antonio Cambule
(STÜBER SYSTEMS) wrote:<br>
</div>
<blockquote
cite="mid:DB6...@DB..."
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.E-MailFormatvorlage17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;
mso-fareast-language:EN-US;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Pablo,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I did that and
got the same error.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Here is the
Query without that <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">SELECT <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> "Lehrer"."Nachname",
"Lehrer"."Vorname", "Lehrer"."Telefon", "Lehrer"."Mandant",
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> "Lehrer"."Status",
"AuswahlLehrer"."Mandant", "Lehrer"."Geburtsdatum",
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> "Lehrer"."Staatsangeh",
"Lehrer"."Strasse", "Lehrer"."Ort", "Lehrer"."Email",
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> "Lehrer"."ZugangDatum",
"Lehrer"."Dienstalter", "Lehrer"."LetzteUeberpruefung",
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> "Dienstbez"."Bezeichnung",
"Besoldungen"."Bezeichnung", "Lehrer"."Geschlecht",
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> "Lehrer"."Telefax",
"Konfessionen"."Bezeichnung"
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">FROM ((("
"."AuswahlLehrer" "AuswahlLehrer" LEFT OUTER JOIN "
"."Lehrer" "Lehrer" ON
("AuswahlLehrer"."Mandant"="Lehrer"."Mandant") AND
("AuswahlLehrer"."Lehrer"="Lehrer"."ID")) LEFT OUTER JOIN "
"."Besoldungen" "Besoldungen" ON
"Lehrer"."Besoldung"="Besoldungen"."Kuerzel") LEFT OUTER
JOIN " "."Dienstbez" "Dienstbez" ON
"Lehrer"."Dienstbez"="Dienstbez"."Kuerzel") LEFT OUTER JOIN
" "."Konfessionen" "Konfessionen" ON
"Lehrer"."Konfession"="Konfessionen"."Kuerzel"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">WHERE
"Lehrer"."Status"=1 <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">ORDER BY <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> "Lehrer"."Mandant",
"Lehrer"."Nachname", "Lehrer"."Vorname"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">And the error
is on this line:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">FROM ((("
"."AuswahlLehrer" "AuswahlLehrer" LEFT OUTER JOIN "
"."Lehrer" "Lehrer" ON<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">It doesn’t want
the dot, or this kind of syntad: “ “. “AuswahlLehrer“<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Again, the
query is not done by us, but comes from the report in
crystal reports.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I know SQL but
what Crystal produces is strange to me. I always thought it
is the odbc kind of syntax<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">That is used
and that the odbc driver translates it.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Using Easysoft
driver works. <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Antonio<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext;mso-fareast-language:DE"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span
style="color:windowtext;mso-fareast-language:DE">Von:</span></b><span
style="color:windowtext;mso-fareast-language:DE"> Pablo
Sánchez [<a class="moz-txt-link-freetext" href="mailto:pa...@ad...">mailto:pa...@ad...</a>]
<br>
<b>Gesendet:</b> Mittwoch, 12. Oktober 2016 17:49<br>
<b>An:</b> <a class="moz-txt-link-abbreviated" href="mailto:fir...@li...">fir...@li...</a><br>
<b>Betreff:</b> Re: [Firebird-odbc-devel] SQL-Error
using ODBC-Driver 2.0.4 and Crystal Reports 2016<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Antonio, does
this query runs on isql or any db manager ?<br>
<br>
Take the odbc stuff out of it (like opening "{oj " and closing
"}" ) and try a run .<br>
<br>
I see that the query, is shorter than 1165 chars....<br>
<br>
Regards<br>
<br>
Pablo <br>
<br>
<span style="font-size:12.0pt;mso-fareast-language:DE"><o:p></o:p></span></p>
<div>
<p class="MsoNormal">On 10/12/2016 11:04 AM, Antonio Cambule
(STÜBER SYSTEMS) wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">When it comes to execute a crystal
reports file in the –most cases- (not all)<o:p></o:p></p>
<p class="MsoNormal">this error is thrown:<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Fehler beim Öffnen eines Rowsets.
(english: Error opening rowset)<o:p></o:p></p>
<p class="MsoNormal">Details: HY000:[ODBC Firebird
Driver][Firebird]Dynamic SQL Error<o:p></o:p></p>
<p class="MsoNormal">SQL error code = -104<o:p></o:p></p>
<p class="MsoNormal">Token unkown – line 1, column 1165<o:p></o:p></p>
<p class="MsoNormal">.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Here ist he part oft he odbc.log file:<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Connection=Mage 1b84-12cc ENTER
SQLExecDirectW <o:p></o:p></p>
<p class="MsoNormal">
HSTMT 0x082D1E30<o:p></o:p></p>
<p class="MsoNormal"> WCHAR
* 0x082D21BC [ -3] " SELECT
"Lehrer"."Nachname", "Lehrer"."Vorname", "Lehrer"."Telefon",
"Lehrer"."Mandant", "Lehrer"."Status",
"AuswahlLehrer"."Mandant", "Lehrer"."Geburtsdatum",
"Lehrer"."Staatsangeh", "Lehrer"."Strasse", "Lehrer"."Ort",
"Lehrer"."Email", "Lehrer"."ZugangDatum",
"Lehrer"."Dienstalter", "Lehrer"."LetzteUeberpruefung",
"Dienstbez"."Bezeichnung", "Besoldungen"."Bezeichnung",
"Lehrer"."Geschlecht", "Lehrer"."Telefax",
"Konfessionen"."Bezeichnung" FROM {oj ((("
"."AuswahlLehrer" "AuswahlLehrer" LEFT OUTER JOIN "
"."Lehrer" "Lehrer" ON
("AuswahlLehrer"."Mandant"="Lehrer"."Mandant") AND
("AuswahlLehrer"."Lehrer"="Lehrer"."ID")) LEFT OUTER JOIN "
"."Besoldungen" "Besoldungen" ON
"Lehrer"."Besoldung"="Besoldungen"."Kuerzel") LEFT OUTER
JOIN " "."Dienstbez" "Dienstbez" ON
"Lehrer"."Dienstbez"="Dienstbez"."Kuerzel") LEFT OUTER JOIN
" "."Konfessionen" "Konfessionen" ON
"Lehrer"."Konfession"="Konfessionen"."Kuerzel"} WHERE
"Lehrer"."Status"=1 ORDER BY "Lehrer"."Mandant",
"Lehrer"."Nachname", "Lehrer"."Vorname"\ 0"<o:p></o:p></p>
<p class="MsoNormal">
SDWORD -3<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Connection=Mage 1b84-12cc EXIT
SQLExecDirectW with return code -1 (SQL_ERROR)<o:p></o:p></p>
<p class="MsoNormal">
HSTMT 0x082D1E30<o:p></o:p></p>
<p class="MsoNormal"> WCHAR
* 0x082D21BC [ -3] " SELECT
"Lehrer"."Nachname", "Lehrer"."Vorname", "Lehrer"."Telefon",
"Lehrer"."Mandant", "Lehrer"."Status",
"AuswahlLehrer"."Mandant", "Lehrer"."Geburtsdatum",
"Lehrer"."Staatsangeh", "Lehrer"."Strasse", "Lehrer"."Ort",
"Lehrer"."Email", "Lehrer"."ZugangDatum",
"Lehrer"."Dienstalter", "Lehrer"."LetzteUeberpruefung",
"Dienstbez"."Bezeichnung", "Besoldungen"."Bezeichnung",
"Lehrer"."Geschlecht", "Lehrer"."Telefax",
"Konfessionen"."Bezeichnung" FROM {oj ((("
"."AuswahlLehrer" "AuswahlLehrer" LEFT OUTER JOIN "
"."Lehrer" "Lehrer" ON
("AuswahlLehrer"."Mandant"="Lehrer"."Mandant") AND
("AuswahlLehrer"."Lehrer"="Lehrer"."ID")) LEFT OUTER JOIN "
"."Besoldungen" "Besoldungen" ON
"Lehrer"."Besoldung"="Besoldungen"."Kuerzel") LEFT OUTER
JOIN " "."Dienstbez" "Dienstbez" ON
"Lehrer"."Dienstbez"="Dienstbez"."Kuerzel") LEFT OUTER JOIN
" "."Konfessionen" "Konfessionen" ON
"Lehrer"."Konfession"="Konfessionen"."Kuerzel"} WHERE
"Lehrer"."Status"=1 ORDER BY "Lehrer"."Mandant",
"Lehrer"."Nachname", "Lehrer"."Vorname"\ 0"<o:p></o:p></p>
<p class="MsoNormal">
SDWORD -3<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> DIAG
[HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error<o:p></o:p></p>
<p class="MsoNormal">SQL error code = -104<o:p></o:p></p>
<p class="MsoNormal">Token unknown - line 1, column 460<o:p></o:p></p>
<p class="MsoNormal">. (-104)<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Is this behaviour known?<o:p></o:p></p>
<p class="MsoNormal">Any idea if this can be solved?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE">regards</span><o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE">Antonio
Cambule</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif;mso-fareast-language:DE"><br>
<br>
<br>
<o:p></o:p></span></p>
<pre>------------------------------------------------------------------------------<o:p></o:p></pre>
<pre>Check out the vibrant tech community on one of the world's most <o:p></o:p></pre>
<pre>engaging tech sites, SlashDot.org! <a moz-do-not-send="true" href="http://sdm.link/slashdot">http://sdm.link/slashdot</a><o:p></o:p></pre>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif;mso-fareast-language:DE"><br>
<br>
<br>
<o:p></o:p></span></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Firebird-odbc-devel mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="mailto:Fir...@li...">Fir...@li...</a><o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel">https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! <a class="moz-txt-link-freetext" href="http://sdm.link/slashdot">http://sdm.link/slashdot</a></pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Firebird-odbc-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Fir...@li...">Fir...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel">https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel</a>
</pre>
</blockquote>
<br>
</body>
</html>
|
