Re: [firebird-support] Timestamp in different regions
Of course your software uses the client-library. Normaly FireDAV uses by
default fbclient.dll. Your software will look at the windows path
I copy the fbclient.dll from firebird install folder to my client program
folder. But be aware to use the right version 32/64Bit! the 32 bit version you
will find at C:\Program Files\Firebird\Firebird_3_0\WOW64, the 64 Bit at
C:\Program Files\Firebird\Firebird_3_0
also copy the two following dll's"msvcr100.dll" and "msvcp100.dll" do your
program folder. This are also an option, that a client PC not has to install
any firebird software. Your program will run without firebird installed (but
just at client-PC's)!
Add a TFDPhysFBDriverLink component to your Delphi project, and define the
propertie VendorLib to e.g. "C:\Temp\myprojectpath\fbclient.dll". What ever you
whant, set the path where the three dll's are!
Gregor
Sent from Yahoo Mail. Get the app
On Thursday, April 30, 2020, 6:52:20 PM GMT+2, 'Zoran' zoran...@gmail.com
[firebird-support] wrote:
Hi Gregor
Thank you for the answer.
I’m using FireDAC components. FB version is 3.0.5. My middle-ware server
program and FB engine are on VPS located in US. I’m developing client app also
in US. All works ok since both programs are in the same region.
I have VM with Win 10 and region set to Europe. I’ve installed FB and server
middle-ware in this VM as well. When I execute client app connecting to US
server, I get the error. When I execute client app connecting to the local
server (which on the same VM machine) all works ok.
I’m not using client-library fbclient.dll or GDS32.dll. This is multi-user app,
some users are in US some are in Europe.
Error happens as soon as I execute ‘qry.Open;’ statement. Karol suggested to
debug the code and I will. But this will go to FireDAC code which is rather
complicated. That’s why I’ve asked here if someone experienced similar problem.
Regards
Zoran
From: firebird-support@yahoogroups.com
Sent: Thursday, April 30, 2020 11:35 AM
To: 'Zoran' zoran...@gmail.com [firebird-support]
Subject: Re: [firebird-support] Timestamp in different regions
Hello Zoran
Witch Component do you useing in Delphi FireDAC?
Are you shure, that that your clients uses the right client-library
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5
What FB Version do you use?
Best Regards
Gregor
Sent from Yahoo Mail. Get the app
On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran' zoran...@gmail.com
[firebird-support] wrote:
Thank you, Karol.
Probably not FB message. I guess it’s coming from Delphi. It happens right
after I execute ‘qry.Open;’ statement..
What I was hopping for is if someone with Delphi background can shed some light
on Delphi handling this situation.
From: firebird-support@yahoogroups.com
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions
I do not suppose that this is Firebird message.
This looks like client program message.
regards,
Karol Bieniaszewski
Firebird 3.0.5, Delphi 10.3.3
In a table I have TIMESTAMP column. If I read that table from the client in the
same Region as server all is ok. If I read the same table where client is in
the different region than server, I get error message 'Could not parse SQL
TimeStamp string'.
In another words if server is in US and client is in US all is ok. If server is
in Europe and client is in Europe, all is ok. But, if server is in US and
client is in Europe (and vice-versa) I get this error.
Does anyone experience this, or am I missing something here?_,
Thank you
Zoran
[Non-text portions of this message have been removed]
#yiv5410137613 #yiv5410137613 -- #yiv5410137613ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5410137613
#yiv5410137613ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5410137613
#yiv5410137613ygrp-mkp #yiv5410137613hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5410137613 #yiv5410137613ygrp-mkp #yiv5410137613ads
{margin-bottom:10px;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad
{padding:0 0;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad p
{margin:0;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad a
{color:#ff;text-decoration:none;}#yiv5410137613 #yiv5410137613ygrp-sponsor
#yiv5410137613ygrp-lc {font-family:Arial;}#yiv5410137613
#yiv5410137613ygrp-sponsor #yiv5410137613ygrp-lc #yiv5410137613hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5410137613
#yiv5410137613ygrp-sponsor #yiv5410137613ygrp-lc .yiv5410137613ad
{margin-bottom:10px;padding:0 0;}#yiv5410137613 #yiv5410137613actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5410137613
#yiv5410137613activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5410137613
#yiv5410137613activity span
Re: [firebird-support] Timestamp in different regions
Hello Zoran
Witch Component do you useing in Delphi FireDAC?
Are you shure, that that your clients uses the right client-library
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5
What FB Version do you use?
Best Regards
Gregor
Sent from Yahoo Mail. Get the app
On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran'
zoran...@gmail..com [firebird-support]
wrote:
Thank you, Karol.
Probably not FB message. I guess it’s coming from Delphi. It happens right
after I execute ‘qry.Open;’ statement.
What I was hopping for is if someone with Delphi background can shed some light
on Delphi handling this situation.
From: firebird-support@yahoogroups.com
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions
I do not suppose that this is Firebird message.
This looks like client program message.
regards,
Karol Bieniaszewski
Firebird 3.0.5, Delphi 10.3.3
In a table I have TIMESTAMP column. If I read that table from the client in the
same Region as server all is ok. If I read the same table where client is in
the different region than server, I get error message 'Could not parse SQL
TimeStamp string'.
In another words if server is in US and client is in US all is ok. If server is
in Europe and client is in Europe, all is ok. But, if server is in US and
client is in Europe (and vice-versa) I get this error.
Does anyone experience this, or am I missing something here?_,
Thank you
Zoran
#yiv7077494043 #yiv7077494043 -- #yiv7077494043ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7077494043
#yiv7077494043ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7077494043
#yiv7077494043ygrp-mkp #yiv7077494043hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7077494043 #yiv7077494043ygrp-mkp #yiv7077494043ads
{margin-bottom:10px;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad
{padding:0 0;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad p
{margin:0;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad a
{color:#ff;text-decoration:none;}#yiv7077494043 #yiv7077494043ygrp-sponsor
#yiv7077494043ygrp-lc {font-family:Arial;}#yiv7077494043
#yiv7077494043ygrp-sponsor #yiv7077494043ygrp-lc #yiv7077494043hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7077494043
#yiv7077494043ygrp-sponsor #yiv7077494043ygrp-lc .yiv7077494043ad
{margin-bottom:10px;padding:0 0;}#yiv7077494043 #yiv7077494043actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7077494043
#yiv7077494043activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7077494043
#yiv7077494043activity span {font-weight:700;}#yiv7077494043
#yiv7077494043activity span:first-child
{text-transform:uppercase;}#yiv7077494043 #yiv7077494043activity span a
{color:#5085b6;text-decoration:none;}#yiv7077494043 #yiv7077494043activity span
span {color:#ff7900;}#yiv7077494043 #yiv7077494043activity span
.yiv7077494043underline {text-decoration:underline;}#yiv7077494043
.yiv7077494043attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7077494043 .yiv7077494043attach div a
{text-decoration:none;}#yiv7077494043 .yiv7077494043attach img
{border:none;padding-right:5px;}#yiv7077494043 .yiv7077494043attach label
{display:block;margin-bottom:5px;}#yiv7077494043 .yiv7077494043attach label a
{text-decoration:none;}#yiv7077494043 blockquote {margin:0 0 0
4px;}#yiv7077494043 .yiv7077494043bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7077494043
.yiv7077494043bold a {text-decoration:none;}#yiv7077494043 dd.yiv7077494043last
p a {font-family:Verdana;font-weight:700;}#yiv7077494043 dd.yiv7077494043last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7077494043
dd.yiv7077494043last p span.yiv7077494043yshortcuts
{margin-right:0;}#yiv7077494043 div.yiv7077494043attach-table div div a
{text-decoration:none;}#yiv7077494043 div.yiv7077494043attach-table
{width:400px;}#yiv7077494043 div.yiv7077494043file-title a, #yiv7077494043
div.yiv7077494043file-title a:active, #yiv7077494043
div.yiv7077494043file-title a:hover, #yiv7077494043 div.yiv7077494043file-title
a:visited {text-decoration:none;}#yiv7077494043 div.yiv7077494043photo-title a,
#yiv7077494043 div.yiv7077494043photo-title a:active, #yiv7077494043
div.yiv7077494043photo-title a:hover, #yiv7077494043
div.yiv7077494043photo-title a:visited {text-decoration:none;}#yiv7077494043
div#yiv7077494043ygrp-mlmsg #yiv7077494043ygrp-msg p a
span.yiv7077494043yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7077494043
.yiv7077494043green {color:#628c2a;}#yiv7077494043 .yiv7077494043MsoNormal
{margin:0 0 0 0;}#yiv7077494043 o {font-size:0;}#yiv7077494043
Re: [firebird-support] Firebird 4.0.0-1436 beta 1
Thanks a lot. Now it works.
Gregor
Sent from Yahoo Mail. Get the app
On Wednesday, March 25, 2020, 2:27:12 PM GMT+1, Mark Rotteveel
m...@lawinegevaar.nl [firebird-support]
wrote:
On 2020-03-25 13:24, Gregor Kobler gregorkob...@yahoo.com
[firebird-support] wrote:
> Hello Mark
>
> Yes I am aware of that, but I have no experience with the snapshots.
> How do I make the current snapshot work. I run the file
> "Install_service.bat". The Firebird service is running, but when I try
> to connect, the following message appears
>
> Install incomplete, please read the Compatibility chapter in the
> release notes for this version.
That is because your security database hasn't been initialized yet for
the SRP authentication plugin. This isn't new, the same error would
occur with Firebird 3.
To fix this you need to create a SRP user. To do that, stop the firebird
service, run
isql -user sysdba employee
create user sysdba password '';
exit;
And start the Firebird service again.
Mark
#yiv2216239056 #yiv2216239056 -- #yiv2216239056ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2216239056
#yiv2216239056ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2216239056
#yiv2216239056ygrp-mkp #yiv2216239056hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2216239056 #yiv2216239056ygrp-mkp #yiv2216239056ads
{margin-bottom:10px;}#yiv2216239056 #yiv2216239056ygrp-mkp .yiv2216239056ad
{padding:0 0;}#yiv2216239056 #yiv2216239056ygrp-mkp .yiv2216239056ad p
{margin:0;}#yiv2216239056 #yiv2216239056ygrp-mkp .yiv2216239056ad a
{color:#ff;text-decoration:none;}#yiv2216239056 #yiv2216239056ygrp-sponsor
#yiv2216239056ygrp-lc {font-family:Arial;}#yiv2216239056
#yiv2216239056ygrp-sponsor #yiv2216239056ygrp-lc #yiv2216239056hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2216239056
#yiv2216239056ygrp-sponsor #yiv2216239056ygrp-lc .yiv2216239056ad
{margin-bottom:10px;padding:0 0;}#yiv2216239056 #yiv2216239056actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2216239056
#yiv2216239056activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2216239056
#yiv2216239056activity span {font-weight:700;}#yiv2216239056
#yiv2216239056activity span:first-child
{text-transform:uppercase;}#yiv2216239056 #yiv2216239056activity span a
{color:#5085b6;text-decoration:none;}#yiv2216239056 #yiv2216239056activity span
span {color:#ff7900;}#yiv2216239056 #yiv2216239056activity span
.yiv2216239056underline {text-decoration:underline;}#yiv2216239056
.yiv2216239056attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2216239056 .yiv2216239056attach div a
{text-decoration:none;}#yiv2216239056 .yiv2216239056attach img
{border:none;padding-right:5px;}#yiv2216239056 .yiv2216239056attach label
{display:block;margin-bottom:5px;}#yiv2216239056 .yiv2216239056attach label a
{text-decoration:none;}#yiv2216239056 blockquote {margin:0 0 0
4px;}#yiv2216239056 .yiv2216239056bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2216239056
.yiv2216239056bold a {text-decoration:none;}#yiv2216239056 dd.yiv2216239056last
p a {font-family:Verdana;font-weight:700;}#yiv2216239056 dd.yiv2216239056last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2216239056
dd.yiv2216239056last p span.yiv2216239056yshortcuts
{margin-right:0;}#yiv2216239056 div.yiv2216239056attach-table div div a
{text-decoration:none;}#yiv2216239056 div.yiv2216239056attach-table
{width:400px;}#yiv2216239056 div.yiv2216239056file-title a, #yiv2216239056
div.yiv2216239056file-title a:active, #yiv2216239056
div.yiv2216239056file-title a:hover, #yiv2216239056 div.yiv2216239056file-title
a:visited {text-decoration:none;}#yiv2216239056 div.yiv2216239056photo-title a,
#yiv2216239056 div.yiv2216239056photo-title a:active, #yiv2216239056
div.yiv2216239056photo-title a:hover, #yiv2216239056
div.yiv2216239056photo-title a:visited {text-decoration:none;}#yiv2216239056
div#yiv2216239056ygrp-mlmsg #yiv2216239056ygrp-msg p a
span.yiv2216239056yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2216239056
.yiv2216239056green {color:#628c2a;}#yiv2216239056 .yiv2216239056MsoNormal
{margin:0 0 0 0;}#yiv2216239056 o {font-size:0;}#yiv2216239056
#yiv2216239056photos div {float:left;width:72px;}#yiv2216239056
#yiv2216239056photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv2216239056
#yiv2216239056photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2216239056
#yiv2216239056reco-category {font-size:77%;}#yiv2216239056
#yiv2216239056reco-desc {font-size:77%;}#yiv2216239056 .yiv2216239056replbq
{margin:4px;}#yiv2216239056 #yiv2216239056ygrp-actbar div a:first-child
{margin-right:
Re: [firebird-support] Firebird 4.0.0-1436 beta 1
Hello Mark
Yes I am aware of that, but I have no experience with the snapshots. How do I
make the current snapshot work. I run the file "Install_service.bat". The
Firebird service is running, but when I try to connect, the following message
appears
Install incomplete, please read the Compatibility chapter in the release notes
for this version.
Gregor
Sent from Yahoo Mail. Get the app
On Wednesday, March 25, 2020, 1:06:35 PM GMT+1, Mark Rotteveel
m...@lawinegevaar.nl [firebird-support]
wrote:
On 2020-03-24 10:47, Gregor Kobler gregorkob...@yahoo.com
[firebird-support] wrote:
> Hello
>
> I try a little bit with the FB4 beta 1
>
> two errors i got
> 1. When i try to connect with my 64Bit program and using the
> fbclient.dll (64Bit) my program crashes! when i use the 64bit dll from
> FB3 it works, also when i use the 32bit version with my 32bit program.
> I used the dll from "C:\Program Files\Firebird\Firebird_4_0"
>
> 2. When i try to execute a SQL-Statement like "select * from
> mon$database" if got the follow error with EMS-Firebird Manager
> Unknown SQL Data type (32754).
>
> And my program catches a exception with eurekalog like the follow
> 2.5 Type : EIBNativeException
> 2.6 Message : [FireDAC][Phys][FB]Incorrect values within SQLDA
> structure.
>
> Has somebody a tip? Thanks
If you want to test Firebird 4, consider using one of the snapshots.
Firebird 4 beta 1 is already a year old, so testing against it is not
really of value to the project, because chances are high some problems
are already fixed, and you might miss different, new problems.
Mark
#yiv0697466060 #yiv0697466060 -- #yiv0697466060ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0697466060
#yiv0697466060ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0697466060
#yiv0697466060ygrp-mkp #yiv0697466060hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0697466060 #yiv0697466060ygrp-mkp #yiv0697466060ads
{margin-bottom:10px;}#yiv0697466060 #yiv0697466060ygrp-mkp .yiv0697466060ad
{padding:0 0;}#yiv0697466060 #yiv0697466060ygrp-mkp .yiv0697466060ad p
{margin:0;}#yiv0697466060 #yiv0697466060ygrp-mkp .yiv0697466060ad a
{color:#ff;text-decoration:none;}#yiv0697466060 #yiv0697466060ygrp-sponsor
#yiv0697466060ygrp-lc {font-family:Arial;}#yiv0697466060
#yiv0697466060ygrp-sponsor #yiv0697466060ygrp-lc #yiv0697466060hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0697466060
#yiv0697466060ygrp-sponsor #yiv0697466060ygrp-lc .yiv0697466060ad
{margin-bottom:10px;padding:0 0;}#yiv0697466060 #yiv0697466060actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0697466060
#yiv0697466060activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0697466060
#yiv0697466060activity span {font-weight:700;}#yiv0697466060
#yiv0697466060activity span:first-child
{text-transform:uppercase;}#yiv0697466060 #yiv0697466060activity span a
{color:#5085b6;text-decoration:none;}#yiv0697466060 #yiv0697466060activity span
span {color:#ff7900;}#yiv0697466060 #yiv0697466060activity span
.yiv0697466060underline {text-decoration:underline;}#yiv0697466060
.yiv0697466060attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0697466060 .yiv0697466060attach div a
{text-decoration:none;}#yiv0697466060 .yiv0697466060attach img
{border:none;padding-right:5px;}#yiv0697466060 .yiv0697466060attach label
{display:block;margin-bottom:5px;}#yiv0697466060 .yiv0697466060attach label a
{text-decoration:none;}#yiv0697466060 blockquote {margin:0 0 0
4px;}#yiv0697466060 .yiv0697466060bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0697466060
.yiv0697466060bold a {text-decoration:none;}#yiv0697466060 dd.yiv0697466060last
p a {font-family:Verdana;font-weight:700;}#yiv0697466060 dd.yiv0697466060last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0697466060
dd.yiv0697466060last p span.yiv0697466060yshortcuts
{margin-right:0;}#yiv0697466060 div.yiv0697466060attach-table div div a
{text-decoration:none;}#yiv0697466060 div.yiv0697466060attach-table
{width:400px;}#yiv0697466060 div.yiv0697466060file-title a, #yiv0697466060
div.yiv0697466060file-title a:active, #yiv0697466060
div.yiv0697466060file-title a:hover, #yiv0697466060 div.yiv0697466060file-title
a:visited {text-decoration:none;}#yiv0697466060 div.yiv0697466060photo-title a,
#yiv0697466060 div.yiv0697466060photo-title a:active, #yiv0697466060
div.yiv0697466060photo-title a:hover, #yiv0697466060
div.yiv0697466060photo-title a:visited {text-decoration:none;}#yiv0697466060
div#yiv0697466060ygrp-mlmsg #yiv0697466060ygrp-msg p a
span.yiv0697466060yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0697466060
.yiv0697466060green {color:#628c
Re: [firebird-support] Re: Firebird 4.0.0-1436 beta 1
There are no an installer for Built 1815, and I don't have any exprerience how to make a snapshot running. Also i din't find any solution at the web. Could you explain me that. The fbclient.dll Built 1815-64bit works with beta 1. But the new field typ Timestamp_tz are a bigger problem. So i think, we running into a compatibility problem with older developer systems. I use Delphi Rio 10.3.3 with FireDAC, but its not possible for me to compile a running program right now?! Best RegardsGregor Sent from Yahoo Mail. Get the app On Tuesday, March 24, 2020, 1:04:41 PM GMT+1, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit : > Hello > > I try a little bit with the FB4 beta 1 > > two errors i got > 1. When i try to connect with my 64Bit program and using the fbclient.dll > (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also > when i use the 32bit version with my 32bit program. I used the dll from > "C:\Program Files\Firebird\Firebird_4_0" > > 2. When i try to execute a SQL-Statement like "select * from mon$database" if > got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754). > > And my program catches a exception with eurekalog like the follow > 2.5 Type : EIBNativeException > 2.6 Message : [FireDAC][Phys][FB]Incorrect values within SQLDA > structure. > > Has somebody a tip? Thanks > > Gregor after a test with the compiled version of the day, indeed, there is the following error if we do not use the 1815 version of fbclient "Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements. Invalid clumplet buffer structure: path length doesn't match with clumplet." -- Norbert Saint Georges http://tetrasys.fi ++ 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] Re: Firebird 4.0.0-1436 beta 1
Hello Norbert Newest version of what? EMS? FDAC? Or FB4? Thx Gregor Sent from Yahoo Mail. Get the app On Tuesday, March 24, 2020, 11:02:39 AM GMT+1, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit : > Hello > > I try a little bit with the FB4 beta 1 > > two errors i got > 1. When i try to connect with my 64Bit program and using the fbclient.dll > (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also > when i use the 32bit version with my 32bit program. I used the dll from > "C:\Program Files\Firebird\Firebird_4_0" > > 2. When i try to execute a SQL-Statement like "select * from mon$database" if > got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754). > > And my program catches a exception with eurekalog like the follow > 2.5 Type : EIBNativeException > 2.6 Message : [FireDAC][Phys][FB]Incorrect values within SQLDA > structure. > > Has somebody a tip? Thanks > > Gregor 32754 = SQL_TIMESTAMP_TZ and EMS and FireDAC does not recognize it yet. You are interested in doing the test with a version compiled with the latest sources -- Norbert Saint Georges http://tetrasys.fi ++ 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
[firebird-support] Firebird 4.0.0-1436 beta 1
Hello I try a little bit with the FB4 beta 1 two errors i got 1. When i try to connect with my 64Bit program and using the fbclient.dll (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also when i use the 32bit version with my 32bit program. I used the dll from "C:\Program Files\Firebird\Firebird_4_0" 2. When i try to execute a SQL-Statement like "select * from mon$database" if got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754). And my program catches a exception with eurekalog like the follow 2.5 Type : EIBNativeException 2.6 Message : [FireDAC][Phys][FB]Incorrect values within SQLDA structure. Has somebody a tip? Thanks Gregor
Re: [firebird-support] Open database connection fails
Hello Dimitry It works now! :-) Thanks for your support Gregor https://support.microsoft.com/en-us/help/239924/how-to-disable-the-media-sensing-feature-for-tcp-ip-in-windows -- WBR, SD. On Monday, June 17, 2019, 11:52:22 AM GMT+2, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 17.06.2019 11:48, gregorkob...@yahoo.com [firebird-support] wrote: > May somebody has me a hint. https://support.microsoft.com/en-us/help/239924/how-to-disable-the-media-sensing-feature-for-tcp-ip-in-windows -- 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] Stored procedure stops functioning correctly after restore under Firebird 3
The restore are not validating the Stored Procedures! After recreation in FB3 you have to validate/compile you SP! Regards Gregor Sent from Yahoo Mail. Get the app https://yho.com/148vdq
