AW: [firebird-support] Firebird 64 Bit Superserver
Hallo Karol, This dll contains many functions to calculate some results (working hour etc.) and the week of year. Last I can get with the extract function, but I don’t know if this is also the correct calculation (with ISO..). Is it better to update to 64Bit or to install classic server? Thanks. Regards Olaf Von: firebird-support@yahoogroups.com Gesendet: Dienstag, 11. Juni 2019 10:40 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] Firebird 64 Bit Superserver Hi >>We are using some Applications, which are not designed for 64 Bit Windows All 32 bit applications should work without problem on 64bit windows >>UDFs, there are not designed for 64 Bit Firebird This is bigger problem. I do not know what your udf functions are, but there are now plenty of built in functions in FB3 version which can replace many old udf Regards, Karol Bieniaszewski
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
solved with something like thatthanks On Wednesday, June 12, 2019, 5:50:52 PM GMT+3, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: Hello, May be you build an empty Fb2.5 database with the same structure (Tables, Generators…)Export the FB3 datas into SQL...Adapt the sql.. and execute them into FB2.5... With best regards,Mikey Le mercredi 12 juin 2019 à 12:57:08 UTC+2, 'Mr.. John' mr_joh...@yahoo.com [firebird-support] a écrit : I've extracted db into a script,but when restoring got almost the same error: Invalid token.Dynamic SQL Error.SQL error code = -104.Token unknown - line 1, column 36.START. error is on every generator code: CREATE GENERATOR GEN_HT_MENT_ID START WITH 0 INCREMENT BY 1; SET GENERATOR GEN_HT_MENT_ID TO 1; in my app I have no such code,for generators I used this: CREATE GENERATOR GEN_HT_MENT_ID;SET GENERATOR GEN_HT_MENT_ID TO 1; thanks thanks On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > what other way I could use? Create database from scratch, pump data. -- WBR, SD. ++ Visit http://www..firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
Hello,
May be you build an empty Fb2.5 database with the same structure (Tables,
Generators…)Export the FB3 datas into SQL...Adapt the sql.. and execute them
into FB2.5...
With best regards,Mikey
Le mercredi 12 juin 2019 à 12:57:08 UTC+2, 'Mr. John' mr_joh...@yahoo.com
[firebird-support] a écrit :
I've extracted db into a script,but when restoring got almost the same error:
Invalid token.Dynamic SQL Error.SQL error code = -104.Token unknown - line 1,
column 36.START.
error is on every generator code:
CREATE GENERATOR GEN_HT_MENT_ID START WITH 0 INCREMENT BY 1;
SET GENERATOR GEN_HT_MENT_ID TO 1;
in my app I have no such code,for generators I used this:
CREATE GENERATOR GEN_HT_MENT_ID;SET GENERATOR GEN_HT_MENT_ID TO 1;
thanks
thanks
On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov
s...@ibphoenix.com [firebird-support] wrote:
12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> what other way I could use?
Create database from scratch, pump data.
--
WBR, SD.
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++
Yahoo Groups Links
#yiv7025946912 #yiv7025946912 -- #yiv7025946912ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7025946912
#yiv7025946912ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7025946912
#yiv7025946912ygrp-mkp #yiv7025946912hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7025946912 #yiv7025946912ygrp-mkp #yiv7025946912ads
{margin-bottom:10px;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad
{padding:0 0;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad p
{margin:0;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad a
{color:#ff;text-decoration:none;}#yiv7025946912 #yiv7025946912ygrp-sponsor
#yiv7025946912ygrp-lc {font-family:Arial;}#yiv7025946912
#yiv7025946912ygrp-sponsor #yiv7025946912ygrp-lc #yiv7025946912hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7025946912
#yiv7025946912ygrp-sponsor #yiv7025946912ygrp-lc .yiv7025946912ad
{margin-bottom:10px;padding:0 0;}#yiv7025946912 #yiv7025946912actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7025946912
#yiv7025946912activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7025946912
#yiv7025946912activity span {font-weight:700;}#yiv7025946912
#yiv7025946912activity span:first-child
{text-transform:uppercase;}#yiv7025946912 #yiv7025946912activity span a
{color:#5085b6;text-decoration:none;}#yiv7025946912 #yiv7025946912activity span
span {color:#ff7900;}#yiv7025946912 #yiv7025946912activity span
.yiv7025946912underline {text-decoration:underline;}#yiv7025946912
.yiv7025946912attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7025946912 .yiv7025946912attach div a
{text-decoration:none;}#yiv7025946912 .yiv7025946912attach img
{border:none;padding-right:5px;}#yiv7025946912 .yiv7025946912attach label
{display:block;margin-bottom:5px;}#yiv7025946912 .yiv7025946912attach label a
{text-decoration:none;}#yiv7025946912 blockquote {margin:0 0 0
4px;}#yiv7025946912 .yiv7025946912bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7025946912
.yiv7025946912bold a {text-decoration:none;}#yiv7025946912 dd.yiv7025946912last
p a {font-family:Verdana;font-weight:700;}#yiv7025946912 dd.yiv7025946912last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7025946912
dd.yiv7025946912last p span.yiv7025946912yshortcuts
{margin-right:0;}#yiv7025946912 div.yiv7025946912attach-table div div a
{text-decoration:none;}#yiv7025946912 div.yiv7025946912attach-table
{width:400px;}#yiv7025946912 div.yiv7025946912file-title a, #yiv7025946912
div.yiv7025946912file-title a:active, #yiv7025946912
div.yiv7025946912file-title a:hover, #yiv7025946912 div.yiv7025946912file-title
a:visited {text-decoration:none;}#yiv7025946912 div.yiv7025946912photo-title a,
#yiv7025946912 div.yiv7025946912photo-title a:active, #yiv7025946912
div.yiv7025946912photo-title a:hover, #yiv7025946912
div.yiv7025946912photo-title a:visited {text-decoration:none;}#yiv7025946912
div#yiv7025946912ygrp-mlmsg #yiv7025946912ygrp-msg p a
span.yiv7025946912yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7025946912
.yiv7025946912green {color:#628c2a;}#yiv7025946912 .yiv7025946912MsoNormal
{margin:0 0 0 0;}#yiv7025946912 o {font-size:0;}#yiv7025946912
#yiv7025946912photos div
Re: [firebird-support] Help interpret plan
Den 2019-06-12 kl. 13:40, skrev Svein Erling Tysvær setys...@gmail.com [firebird-support]: > How many records are there in BUPD, are the other indexes in the plan > selective and can you show us the query? Just wondering if it can be > rewritten so that the query performs better (I assume the reason for > you asking about the plan being that you have a query that is too slow). I could, but there's a left join to F on one col = col from join OR other col in (subselect with where on other col from join), which I don't really think could be improved. I decided to ignore the result of the query. I can achieve what I need by other means. Thanks anyway! To you too Dimitry, for confirming how to interpret the plan, which I have generic use for. :-) Regards, Kjell [Non-text portions of this message have been removed]
Re: [firebird-support] Help interpret plan
How many records are there in BUPD, are the other indexes in the plan selective and can you show us the query? Just wondering if it can be rewritten so that the query performs better (I assume the reason for you asking about the plan being that you have a query that is too slow). Set ons. 12. jun. 2019 kl. 12:38 skrev Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] : > 12.06.2019 12:37, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: > > Would this mean that the table F would be subject to a full natural scan > > for each record of the preceding joins? > >Yes. > > > -- >WBR, SD. > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
12.06.2019 12:53, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I've extracted db into a script You must have a "master script" instead of extracting metadata from live database. Ask the database author for it. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Unsubscribe
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
I've extracted db into a script,but when restoring got almost the same error: Invalid token.Dynamic SQL Error.SQL error code = -104.Token unknown - line 1, column 36.START. error is on every generator code: CREATE GENERATOR GEN_HT_MENT_ID START WITH 0 INCREMENT BY 1; SET GENERATOR GEN_HT_MENT_ID TO 1; in my app I have no such code,for generators I used this: CREATE GENERATOR GEN_HT_MENT_ID;SET GENERATOR GEN_HT_MENT_ID TO 1; thanks thanks On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > what other way I could use? Create database from scratch, pump data. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] Help interpret plan
12.06.2019 12:37, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Would this mean that the table F would be subject to a full natural scan > for each record of the preceding joins? Yes. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Help interpret plan
I got this plan for a query:
PLAN SORT (
JOIN (
JOIN (
JOIN (
BUPD NATURAL,
UPD INDEX ("IX_PK_Uppdatering"),
SP INDEX ("IX_Uppgiftsspärr_TilläG2M")
),
E INDEX ("IX_Epostadress_UppgiftLZH")
),
F NATURAL
)
)
Would this mean that the table F would be subject to a full natural scan
for each record of the preceding joins?
Or does it mean that F is scanned once during which each F record is
matched against the result set of the joins?
F is large (well, ~3 million records) and the join result set is small
(~1 records).
Mvh,
Kjell
[Non-text portions of this message have been removed]
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
12.06.2019 12:26, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > based application is written for 2.5,just some test are done for Fb 3,in case > something > goes wrong, must go back to 2.5 until a fix is done,so that restore is need. That's a wrong way of migration. Better set up bi-directional replication between old server and new one. In this case you can switch back in no time without data being lost. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
Hibased application is written for 2.5,just some test are done for Fb 3,in case something goes wrong, must go back to 2.5 until a fix is done,so that restore is need.thanks On Wednesday, June 12, 2019, 1:00:33 PM GMT+3, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: Hello, I know that FB2.5 to F3.0 is possible :First do backup under FB2.5 and after restore under FB3... But I may not understand your problem : do you want to do an FB3 -> FB2.5 restore ?IF yes I may presume this is impossible… I'm right ? With best Regards,Mickey Le mercredi 12 juin 2019 à 11:50:55 UTC+2, 'Mr.. John' mr_joh...@yahoo.com [firebird-support] a écrit : HiI'm trying to restore a FB 3 database to 2.5Before fb3 backup,I copy from 2.5 gbak.exe to gbak2.exe into FB3 folderthen run gbak2.exe -v -b "d:\db3.fdb" "d:\dbbk.gbk" -user SYSDBA -pass "mypass" backup is done with no erorrs I can restore it again to fb3 with no error but when I restore it to Fb2.5 I got this: Starting restore. Current time: 12:25:06 PM Invalid token. invalid request BLR at offset 27. BLR syntax error: expected valid BLR code at offset 28, encountered 210. Exiting before completion due to errors. Restore completed. Current time: 12:25:08 PM. Elapsed time: 00:00:01 restore is done from IBExpert thanks
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > what other way I could use? Create database from scratch, pump data. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
hi the based application is written for 2.5 and then compiled for fb3,no new fb 3 field type or code,the only thing done is that new SP code protection/remove: update RDB$PROCEDURES set rdb$procedure_source = NULL where rdb$procedure_name STARTING WITH instead of 2.5 UPDATE RDB$TRIGGERS SET RDB$TRIGGER_SOURCE = NULL WHERE RDB$SYSTEM_FLAG IS NULL OR RDB$SYSTEM_FLAG=0; UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL WHERE RDB$SYSTEM_FLAG IS NULL OR RDB$SYSTEM_FLAG=0; what other way I could use? thanks On Wednesday, June 12, 2019, 12:55:20 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.06.2019 11:38, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > Invalid token. > invalid request BLR at offset 27. > BLR syntax error: expected valid BLR code at offset 28, encou ntered >210. This database obviously used some new features of Firebird 3 in stored code. It cannot be downgraded by backup-restore. Use other ways. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
Hello,
I know that FB2.5 to F3.0 is possible :First do backup under FB2.5 and after
restore under FB3...
But I may not understand your problem : do you want to do an FB3 -> FB2.5
restore ?IF yes I may presume this is impossible… I'm right ?
With best Regards,Mickey
Le mercredi 12 juin 2019 à 11:50:55 UTC+2, 'Mr. John' mr_joh...@yahoo.com
[firebird-support] a écrit :
HiI'm trying to restore a FB 3 database to 2.5Before fb3 backup,I copy from 2.5
gbak.exe to gbak2.exe into FB3 folderthen run
gbak2.exe -v -b "d:\db3.fdb" "d:\dbbk.gbk" -user SYSDBA -pass "mypass"
backup is done with no erorrs
I can restore it again to fb3 with no error but when I restore it to Fb2.5 I
got this:
Starting restore. Current time: 12:25:06 PM Invalid token. invalid request
BLR at offset 27. BLR syntax error: expected valid BLR code at offset 28,
encountered 210. Exiting before completion due to errors. Restore
completed. Current time: 12:25:08 PM. Elapsed time: 00:00:01
restore is done from IBExpert
thanks #yiv1968461019 #yiv1968461019 -- #yiv1968461019ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1968461019
#yiv1968461019ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1968461019
#yiv1968461019ygrp-mkp #yiv1968461019hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1968461019 #yiv1968461019ygrp-mkp #yiv1968461019ads
{margin-bottom:10px;}#yiv1968461019 #yiv1968461019ygrp-mkp .yiv1968461019ad
{padding:0 0;}#yiv1968461019 #yiv1968461019ygrp-mkp .yiv1968461019ad p
{margin:0;}#yiv1968461019 #yiv1968461019ygrp-mkp .yiv1968461019ad a
{color:#ff;text-decoration:none;}#yiv1968461019 #yiv1968461019ygrp-sponsor
#yiv1968461019ygrp-lc {font-family:Arial;}#yiv1968461019
#yiv1968461019ygrp-sponsor #yiv1968461019ygrp-lc #yiv1968461019hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1968461019
#yiv1968461019ygrp-sponsor #yiv1968461019ygrp-lc .yiv1968461019ad
{margin-bottom:10px;padding:0 0;}#yiv1968461019 #yiv1968461019actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1968461019
#yiv1968461019activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1968461019
#yiv1968461019activity span {font-weight:700;}#yiv1968461019
#yiv1968461019activity span:first-child
{text-transform:uppercase;}#yiv1968461019 #yiv1968461019activity span a
{color:#5085b6;text-decoration:none;}#yiv1968461019 #yiv1968461019activity span
span {color:#ff7900;}#yiv1968461019 #yiv1968461019activity span
.yiv1968461019underline {text-decoration:underline;}#yiv1968461019
.yiv1968461019attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1968461019 ..yiv1968461019attach div a
{text-decoration:none;}#yiv1968461019 .yiv1968461019attach img
{border:none;padding-right:5px;}#yiv1968461019 .yiv1968461019attach label
{display:block;margin-bottom:5px;}#yiv1968461019 .yiv1968461019attach label a
{text-decoration:none;}#yiv1968461019 blockquote {margin:0 0 0
4px;}#yiv1968461019 .yiv1968461019bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1968461019
.yiv1968461019bold a {text-decoration:none;}#yiv1968461019 dd.yiv1968461019last
p a {font-family:Verdana;font-weight:700;}#yiv1968461019 dd.yiv1968461019last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1968461019
dd.yiv1968461019last p span.yiv1968461019yshortcuts
{margin-right:0;}#yiv1968461019 div.yiv1968461019attach-table div div a
{text-decoration:none;}#yiv1968461019 div.yiv1968461019attach-table
{width:400px;}#yiv1968461019 div.yiv1968461019file-title a, #yiv1968461019
div.yiv1968461019file-title a:active, #yiv1968461019
div.yiv1968461019file-title a:hover, #yiv1968461019 div.yiv1968461019file-title
a:visited {text-decoration:none;}#yiv1968461019 div.yiv1968461019photo-title a,
#yiv1968461019 div.yiv1968461019photo-title a:active, #yiv1968461019
div.yiv1968461019photo-title a:hover, #yiv1968461019
div.yiv1968461019photo-title a:visited {text-decoration:none;}#yiv1968461019
div#yiv1968461019ygrp-mlmsg #yiv1968461019ygrp-msg p a
span.yiv1968461019yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1968461019
.yiv1968461019green {color:#628c2a;}#yiv1968461019 .yiv1968461019MsoNormal
{margin:0 0 0 0;}#yiv1968461019 o {font-size:0;}#yiv1968461019
#yiv1968461019photos div {float:left;width:72px;}#yiv1968461019
#yiv1968461019photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv1968461019
#yiv1968461019photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1968461019
#yiv1968461019reco-category {font-size:77%;}#yiv1968461019
#yiv1968461019reco-desc {font-size:77%;}#yiv1968461019 .yiv1968461019replbq
{margin:4px;}#yiv1968461019 #yiv1968461019ygrp-actbar div a:first-child
Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
12.06.2019 11:38, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > Invalid token. > invalid request BLR at offset 27. > BLR syntax error: expected valid BLR code at offset 28, encou ntered > 210. This database obviously used some new features of Firebird 3 in stored code. It cannot be downgraded by backup-restore. Use other ways. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
HiI'm trying to restore a FB 3 database to 2.5Before fb3 backup,I copy from 2.5 gbak.exe to gbak2.exe into FB3 folderthen run gbak2.exe -v -b "d:\db3.fdb" "d:\dbbk.gbk" -user SYSDBA -pass "mypass" backup is done with no erorrs I can restore it again to fb3 with no error but when I restore it to Fb2.5 I got this: Starting restore. Current time: 12:25:06 PM Invalid token. invalid request BLR at offset 27. BLR syntax error: expected valid BLR code at offset 28, encountered 210. Exiting before completion due to errors. Restore completed. Current time: 12:25:08 PM. Elapsed time: 00:00:01 restore is done from IBExpert thanks
