Menu
▾
▴
Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016
|
From: Pablo S. <pa...@ad...> - 2016-10-12 16:06:10
|
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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>
<br>
<div class="moz-cite-prefix">On 10/12/2016 11:04 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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
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;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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">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<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE">Antonio
Cambule<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>
|
