Menu
▾
▴
firebird-odbc-devel — All about development of Firebird ODBC driver donated by IBPhoenix
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(23) |
Sep
(6) |
Oct
(2) |
Nov
(2) |
Dec
(5) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
|
Feb
(14) |
Mar
(16) |
Apr
(14) |
May
(25) |
Jun
(38) |
Jul
(22) |
Aug
(39) |
Sep
(3) |
Oct
(13) |
Nov
(47) |
Dec
(3) |
| 2003 |
Jan
(38) |
Feb
(39) |
Mar
(24) |
Apr
(57) |
May
(30) |
Jun
|
Jul
(39) |
Aug
(90) |
Sep
(41) |
Oct
(141) |
Nov
(158) |
Dec
(137) |
| 2004 |
Jan
(86) |
Feb
(169) |
Mar
(100) |
Apr
(83) |
May
(94) |
Jun
(77) |
Jul
(85) |
Aug
(54) |
Sep
(45) |
Oct
(36) |
Nov
(42) |
Dec
(70) |
| 2005 |
Jan
(46) |
Feb
(44) |
Mar
(50) |
Apr
(73) |
May
(90) |
Jun
(87) |
Jul
(41) |
Aug
(47) |
Sep
(28) |
Oct
(23) |
Nov
(44) |
Dec
(81) |
| 2006 |
Jan
(21) |
Feb
(9) |
Mar
(82) |
Apr
(14) |
May
(109) |
Jun
(175) |
Jul
(188) |
Aug
(44) |
Sep
(5) |
Oct
(47) |
Nov
(15) |
Dec
(34) |
| 2007 |
Jan
(75) |
Feb
(24) |
Mar
(30) |
Apr
(4) |
May
(28) |
Jun
(9) |
Jul
(13) |
Aug
(13) |
Sep
(29) |
Oct
(15) |
Nov
(19) |
Dec
(12) |
| 2008 |
Jan
(7) |
Feb
(19) |
Mar
(1) |
Apr
(7) |
May
(13) |
Jun
(19) |
Jul
(17) |
Aug
(29) |
Sep
(15) |
Oct
(37) |
Nov
(18) |
Dec
(29) |
| 2009 |
Jan
(23) |
Feb
(12) |
Mar
(8) |
Apr
(16) |
May
(11) |
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
|
Oct
(9) |
Nov
(17) |
Dec
(31) |
| 2010 |
Jan
(15) |
Feb
(5) |
Mar
(4) |
Apr
(8) |
May
(1) |
Jun
(5) |
Jul
(17) |
Aug
(2) |
Sep
(12) |
Oct
(33) |
Nov
(14) |
Dec
(24) |
| 2011 |
Jan
(11) |
Feb
(2) |
Mar
(34) |
Apr
(11) |
May
(12) |
Jun
(3) |
Jul
(6) |
Aug
(11) |
Sep
(10) |
Oct
(1) |
Nov
(8) |
Dec
|
| 2012 |
Jan
(16) |
Feb
(2) |
Mar
|
Apr
(2) |
May
(6) |
Jun
(2) |
Jul
(7) |
Aug
|
Sep
|
Oct
(7) |
Nov
(22) |
Dec
(2) |
| 2013 |
Jan
(1) |
Feb
(24) |
Mar
(15) |
Apr
(2) |
May
(3) |
Jun
|
Jul
(2) |
Aug
|
Sep
(2) |
Oct
(6) |
Nov
(10) |
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(4) |
Nov
|
Dec
(5) |
| 2015 |
Jan
(1) |
Feb
(4) |
Mar
(3) |
Apr
(3) |
May
|
Jun
(3) |
Jul
(1) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
(9) |
Mar
(4) |
Apr
|
May
(6) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(7) |
Nov
(13) |
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(12) |
Oct
(4) |
Nov
|
Dec
|
| 2018 |
Jan
(6) |
Feb
|
Mar
|
Apr
|
May
(6) |
Jun
|
Jul
(9) |
Aug
(4) |
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
(1) |
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
(3) |
Aug
|
Sep
|
Oct
(3) |
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(4) |
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2025 |
Jan
|
Feb
(2) |
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <gmi...@gm...> - 2016-11-08 11:50:09
|
? tcip/IP string ? what do you mean ? it like \\192.168.1.1\sharedfolder\data\file.FDB ? -----Message d'origine----- De : Dimitry Sibiryakov [mailto:sd...@ib...] Envoyé : mardi 8 novembre 2016 12:39 À : fir...@li... Objet : Re: [Firebird-odbc-devel] Access odbc firebird 08.11.2016 12:16, gmi...@gm... wrote: > the path are correct and the database is present > I don't understand Something may block named pipes. Try to use TCP/IP connection string. -- WBR, SD. ---------------------------------------------------------------------------- -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Dimitry S. <sd...@ib...> - 2016-11-08 11:46:34
|
08.11.2016 12:41, gmi...@gm... wrote: > I have installed firebird in local machine but the FDB file is on network > shared folder Firebird cannot work with databases on network folders. -- WBR, SD. |
|
From: <gmi...@gm...> - 2016-11-08 11:41:59
|
I have installed firebird in local machine but the FDB file is on network shared folder Strange...... -----Message d'origine----- De : Dimitry Sibiryakov [mailto:sd...@ib...] Envoyé : mardi 8 novembre 2016 11:47 À : fir...@li... Objet : Re: [Firebird-odbc-devel] Access odbc firebird 08.11.2016 11:35, gmi...@gm... wrote: > do you have a idea for this problem ? Yes: you must have Firbird server running on the host where database is. -- WBR, SD. ---------------------------------------------------------------------------- -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Dimitry S. <sd...@ib...> - 2016-11-08 11:39:16
|
08.11.2016 12:16, gmi...@gm... wrote: > the path are correct and the database is present > I don't understand Something may block named pipes. Try to use TCP/IP connection string. -- WBR, SD. |
|
From: <gmi...@gm...> - 2016-11-08 11:16:29
|
Hi thanks you for your response. Firebird server is running on the same host where database is. (IP : 192.168.1.1) but MSAccess client who want to make a odbc link are in the network (IP : 192.168.1.5) >From (IP : 192.168.1.5) in MsAccess i try to make a link connection by odbc driver but without success. the path are correct and the database is present I don't understand -----Message d'origine----- De : Dimitry Sibiryakov [mailto:sd...@ib...] Envoyé : mardi 8 novembre 2016 11:47 À : fir...@li... Objet : Re: [Firebird-odbc-devel] Access odbc firebird 08.11.2016 11:35, gmi...@gm... wrote: > do you have a idea for this problem ? Yes: you must have Firbird server running on the host where database is. -- WBR, SD. ---------------------------------------------------------------------------- -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Dimitry S. <sd...@ib...> - 2016-11-08 10:46:45
|
08.11.2016 11:35, gmi...@gm... wrote: > do you have a idea for this problem ? Yes: you must have Firbird server running on the host where database is. -- WBR, SD. |
|
From: <gmi...@gm...> - 2016-11-08 10:36:05
|
Hi everybody, I use firebird odbc (last version) and try to connect by MsAccess 2016 My database is on a network shared folder, but i can't connect to it by \\IP\shared\database\file.FDB I have got a Message : ERROR : Connection failed : unable to complete network request, failed to etablish a connection do you have a idea for this problem ? Regards gmisk |
|
From: Antonio C. (S. S. <Ant...@st...> - 2016-10-31 11:05:30
|
Hi there again,
i’ve tried every config combination of the driver, it didn’t work.
I have taken a look at the driver we use now… and see there, it is this driver in version 1.03.00.89.
Just by updating to the next available version 1.03.00.96 it gives back the error.
Regards
Antonio
Von: Pablo Sánchez [mailto:pa...@ad...]
Gesendet: Donnerstag, 13. Oktober 2016 14:53
An: fir...@li...
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 autoquoted identifier.
Regards
Pablo
On 10/13/2016 05:10 AM, Antonio Cambule (STÜBER SYSTEMS) wrote:
Hi Pablo,
I did that and got the same error.
Here is the Query without that
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 (((" "."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"
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 of syntad: “ “. “AuswahlLehrer“
Again, the query is not done by us, but comes from the report in crystal reports.
I know SQL but what Crystal produces is strange to me. I always thought it is the odbc kind of syntax
That is used and that the odbc driver translates it.
Using Easysoft driver works.
Regards
Antonio
Von: Pablo Sánchez [mailto:pa...@ad...]
Gesendet: Mittwoch, 12. Oktober 2016 17:49
An: fir...@li...<mailto:fir...@li...>
Betreff: Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016
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, Antonio Cambule (STÜBER SYSTEMS) wrote:
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
.
Here ist he part oft he odbc.log file:
Connection=Mage 1b84-12cc ENTER SQLExecDirectW
HSTMT 0x082D1E30
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"
SDWORD -3
Connection=Mage 1b84-12cc EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 0x082D1E30
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"
SDWORD -3
DIAG [HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 460
. (-104)
Is this behaviour known?
Any idea if this can be solved?
regards
Antonio Cambule
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...<mailto:Fir...@li...>
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...<mailto:Fir...@li...>
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
|
|
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>
|
|
From: Antonio C. (S. S. <Ant...@st...> - 2016-10-13 08:10:39
|
Hi Pablo,
I did that and got the same error.
Here is the Query without that
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 (((" "."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"
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 of syntad: “ “. “AuswahlLehrer“
Again, the query is not done by us, but comes from the report in crystal reports.
I know SQL but what Crystal produces is strange to me. I always thought it is the odbc kind of syntax
That is used and that the odbc driver translates it.
Using Easysoft driver works.
Regards
Antonio
Von: Pablo Sánchez [mailto:pa...@ad...]
Gesendet: Mittwoch, 12. Oktober 2016 17:49
An: fir...@li...
Betreff: Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016
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, Antonio Cambule (STÜBER SYSTEMS) wrote:
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
.
Here ist he part oft he odbc.log file:
Connection=Mage 1b84-12cc ENTER SQLExecDirectW
HSTMT 0x082D1E30
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"
SDWORD -3
Connection=Mage 1b84-12cc EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 0x082D1E30
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"
SDWORD -3
DIAG [HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 460
. (-104)
Is this behaviour known?
Any idea if this can be solved?
regards
Antonio Cambule
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...<mailto:Fir...@li...>
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
|
|
From: Antonio C. (S. S. <Ant...@st...> - 2016-10-13 08:04:27
|
Hi, i turned on firebird audit and trace but the file does not show the sql select from the odbc. Is there a special switch i need to use? regards Antonio Cambule -----Ursprüngliche Nachricht----- Von: Dimitry Sibiryakov [mailto:sd...@ib...] Gesendet: Mittwoch, 12. Oktober 2016 16:29 An: fir...@li... 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 after ODBC driver transformed ODBC join into ANSI join. Avoid mixing of these types of joins in one query. -- WBR, SD. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
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>
|
|
From: Dimitry S. <sd...@ib...> - 2016-10-12 14:29:26
|
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. |
|
From: Antonio C. (S. S. <Ant...@st...> - 2016-10-12 14:20:21
|
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
.
Here ist he part oft he odbc.log file:
Connection=Mage 1b84-12cc ENTER SQLExecDirectW
HSTMT 0x082D1E30
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"
SDWORD -3
Connection=Mage 1b84-12cc EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 0x082D1E30
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"
SDWORD -3
DIAG [HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 460
. (-104)
Is this behaviour known?
Any idea if this can be solved?
regards
Antonio Cambule
|
|
From: Robert M. <ro...@ch...> - 2016-05-12 20:58:19
|
Hi I only sue ODBC to connect Crystal reports and I don't use access but it occurs to me the issue is likely to be that the process takes longer in FB 3 and the access (periodically) silently times out. So you call your SQL / Stored procedure it takes longer than x seconds so access just gives up and steps to the next line of code, however the SQL is still running in FB and later completes. I would look for timeout settings and check your SQLs execute within them. Cheers Rob On 13/05/2016 4:35 a.m., Olaf Kluge wrote: > .. and why works it sometimes and otherwhile not :( > > > > -----Ursprüngliche Nachricht----- > Von: Olaf Kluge [mailto:ola...@sa...] > Gesendet: Donnerstag, 12. Mai 2016 18:30 > An: fir...@li... > Betreff: Re: [Firebird-odbc-devel] ODBC-Problems > > Hello , > > I was just wondering why it works with the old 2.00.150 driver nearly > perfect and with the new so bad. What can I do? The Access should wait until > the record is in the table, with the earlier version this works.. > > 12.05.2016 17:48, Olaf Kluge wrote: >> Now, after we call a sp access gets not in every time the new records >> (the sp inserts for example one), only after the formular is closes >> (or the entire access), the records will be shown. > This is obviously a problem with Access transactions handling. > |
|
From: Olaf K. <ola...@sa...> - 2016-05-12 16:35:34
|
.. and why works it sometimes and otherwhile not :( -----Ursprüngliche Nachricht----- Von: Olaf Kluge [mailto:ola...@sa...] Gesendet: Donnerstag, 12. Mai 2016 18:30 An: fir...@li... Betreff: Re: [Firebird-odbc-devel] ODBC-Problems Hello , I was just wondering why it works with the old 2.00.150 driver nearly perfect and with the new so bad. What can I do? The Access should wait until the record is in the table, with the earlier version this works.. 12.05.2016 17:48, Olaf Kluge wrote: > Now, after we call a sp access gets not in every time the new records > (the sp inserts for example one), only after the formular is closes > (or the entire access), the records will be shown. This is obviously a problem with Access transactions handling. -- WBR, SD. ---------------------------------------------------------------------------- -- Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel ---------------------------------------------------------------------------- -- Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Olaf K. <ola...@sa...> - 2016-05-12 16:30:07
|
Hello , I was just wondering why it works with the old 2.00.150 driver nearly perfect and with the new so bad. What can I do? The Access should wait until the record is in the table, with the earlier version this works.. 12.05.2016 17:48, Olaf Kluge wrote: > Now, after we call a sp access gets not in every time the new records > (the sp inserts for example one), only after the formular is closes > (or the entire access), the records will be shown. This is obviously a problem with Access transactions handling. -- WBR, SD. ---------------------------------------------------------------------------- -- Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Dimitry S. <sd...@ib...> - 2016-05-12 15:55:55
|
12.05.2016 17:48, Olaf Kluge wrote: > Now, after we call a sp access gets not in every time the new records (the sp inserts for > example one), only after the formular is closes (or the entire access), the records will > be shown. This is obviously a problem with Access transactions handling. -- WBR, SD. |
|
From: Olaf K. <ola...@sa...> - 2016-05-12 15:48:50
|
Hello, after we updated the fb odbc driver to 2.04 we have some problems. The frontend is ms access, the tables are linked to firebird and one adodb-connection (every time closed) calls stored procedures. Now, after we call a sp access gets not in every time the new records (the sp inserts for example one), only after the formular is closes (or the entire access), the records will be shown. The old driver 2.00.150 (rc2) works better and faster but since fb 3 I get an error during linking to the tables. Are the tables already linked it works fine. One problem more: We insert in Access a new record in the main-table, after this we go in the ufo (position-table) and everythin is fine, in the second table the reference (year and number) to the main-entry will set. But if we call an stored procedure which inserts this record (special function) and after this we klick to a new record, the given ID (number) is wrong (ID from the insert of the stored procedure). After we klick a second time in the formular, the right number will be shown and the error is not present. The ID will generated with a generator (trigger) in firebird. Thanks for helping. Best regards. Olaf |
|
From: Olaf K. <ola...@sa...> - 2016-05-04 09:48:13
|
Hello, We are using MS Access with the firebird odbc Driver 2.0 RC2. After we had installed the newest one, the adodb-connection which starts a stored procedure in the firebird database does not wait until the results are back to access, the user have to close the formular and reload, only after this the records will be shown. With the old one we have no problem, but the newest one have the Boolean datatype and we would like up to date. What can we do? Best regards. Olaf |
|
From: Heine F. <hei...@gm...> - 2016-03-09 13:47:46
|
Hi, Are you planning to create a new version of the odbc driver that supports the new data types in Firebird 3.0. I'm not aware of all the new Firebird 3 features but I do know about the new boolean and autonumber data types. Are you going to support them? Thanks Heine |
|
From: Dimitry S. <sd...@ib...> - 2016-03-09 12:53:47
|
09.03.2016 13:40, Lawrence Bridger wrote: > Please can anybody suggest a solution or advise me what I might be doing incorrectly to > solve this? If you want a field to get default value, you must not mention the field in INSERT query. -- WBR, SD. |
|
From: Lawrence B. <ad...@br...> - 2016-03-09 12:40:51
|
Hello I have a conundrum which I cannot solve and for which I cannot find a solution in the archives. I have a table with a primary key and one other integer field named, say, ABC. This field is defined as not null but has a default source value of, say, 0. I am using an application which uses the ODBC driver above. I have the option to set this field, within the application, to be a null field. If I do so and try and insert a record I get an error message -625 Validation error for column ABC, value "***null***" . I think that the ODBC driver is looking at the DB table, determining that the field is defined as not null, and therefore produces this error message. If I set the option to not being a null field, the message I get is -303 Dynamic SQL Error SQL error code = -303 conversion error from string "". Again I believe that the DB is receiving a message to insert the record but has determined that the value is blank rather than NULL. In this particular instance I would like the record to be inserted using the default source value, but the error message prevents the update. I have found a work around in that if I was to purchase Easysoft's ODBC driver for Firebird the problem simply disappears, but I do believe that the official Firebird ODBC driver should cope with this scenario. Please can anybody suggest a solution or advise me what I might be doing incorrectly to solve this? Many thanks in advance Lawrence Bridger L D Bridger ACA Managing Director L D Bridger ACA Managing Director ________________________________ bridger Folding Carton Manufacturers Avenue One Letchworth Hertfordshire SG6 2WP Telephone 01462 636465 Web www.bridger.co.uk This e-mail, and any attachment(s), is intended solely for the use of the individual(s) to whom it is addressed. It may contain confidential, proprietary or legally privileged information, none of which is waived or lost by mis-transmission. If you receive this message in error, please delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print or copy any part of this message if you are not the intended recipient. Action taken, or not taken, in reliance of it, is prohibited and may be unlawful. Any views or opinions presented are solely those of the author and do not represent the views of Bridger Packaging. Any e-mail sent to this sender's address might be monitored and/or read by any other employee of Bridger Packaging. Bridger Packaging is a division of T D Bridger Limited Registered in England No. 366193 Registered office as above VAT Registration No. GB 196 2240 57 |
|
From: Heine F. <hei...@gm...> - 2016-03-03 12:47:09
|
Hi, What does the "read (default write) " mean under transactions? Does this change the default to a read transaction? What do the scheme options mean and what is a schema? They are: null field schema, remove schema from query and full schema. Thanks Heine |
|
From: Heine F. <hei...@gm...> - 2016-02-25 14:01:48
|
Hi, I see in the odbc driver there are schema options. Set null field schema, remove schema from query and set full schema. What are these options for? What is a schema and how do you use it? I am using Access 2010 on windows 7 prof. What do you reccomend? Thanks Heine |
71 messages has been excluded from this view by a project administrator.
