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' [email protected]
[firebird-support] <[email protected]> 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: [email protected] <[email protected]>
Sent: Thursday, April 30, 2020 11:35 AM
To: 'Zoran' [email protected] [firebird-support]
<[email protected]>
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' [email protected]
[firebird-support] <[email protected]> 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: [email protected] <[email protected]>
Sent: Thursday, April 30, 2020 11:09 AM
To: [email protected]
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:#0000ff;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 {font-weight:700;}#yiv5410137613
#yiv5410137613activity span:first-child
{text-transform:uppercase;}#yiv5410137613 #yiv5410137613activity span a
{color:#5085b6;text-decoration:none;}#yiv5410137613 #yiv5410137613activity span
span {color:#ff7900;}#yiv5410137613 #yiv5410137613activity span
.yiv5410137613underline {text-decoration:underline;}#yiv5410137613
.yiv5410137613attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5410137613 .yiv5410137613attach div a
{text-decoration:none;}#yiv5410137613 .yiv5410137613attach img
{border:none;padding-right:5px;}#yiv5410137613 .yiv5410137613attach label
{display:block;margin-bottom:5px;}#yiv5410137613 .yiv5410137613attach label a
{text-decoration:none;}#yiv5410137613 blockquote {margin:0 0 0
4px;}#yiv5410137613 .yiv5410137613bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5410137613
.yiv5410137613bold a {text-decoration:none;}#yiv5410137613 dd.yiv5410137613last
p a {font-family:Verdana;font-weight:700;}#yiv5410137613 dd.yiv5410137613last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5410137613
dd.yiv5410137613last p span.yiv5410137613yshortcuts
{margin-right:0;}#yiv5410137613 div.yiv5410137613attach-table div div a
{text-decoration:none;}#yiv5410137613 div.yiv5410137613attach-table
{width:400px;}#yiv5410137613 div.yiv5410137613file-title a, #yiv5410137613
div.yiv5410137613file-title a:active, #yiv5410137613
div.yiv5410137613file-title a:hover, #yiv5410137613 div.yiv5410137613file-title
a:visited {text-decoration:none;}#yiv5410137613 div.yiv5410137613photo-title a,
#yiv5410137613 div.yiv5410137613photo-title a:active, #yiv5410137613
div.yiv5410137613photo-title a:hover, #yiv5410137613
div.yiv5410137613photo-title a:visited {text-decoration:none;}#yiv5410137613
div#yiv5410137613ygrp-mlmsg #yiv5410137613ygrp-msg p a
span.yiv5410137613yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5410137613
.yiv5410137613green {color:#628c2a;}#yiv5410137613 .yiv5410137613MsoNormal
{margin:0 0 0 0;}#yiv5410137613 o {font-size:0;}#yiv5410137613
#yiv5410137613photos div {float:left;width:72px;}#yiv5410137613
#yiv5410137613photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5410137613
#yiv5410137613photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5410137613
#yiv5410137613reco-category {font-size:77%;}#yiv5410137613
#yiv5410137613reco-desc {font-size:77%;}#yiv5410137613 .yiv5410137613replbq
{margin:4px;}#yiv5410137613 #yiv5410137613ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5410137613 #yiv5410137613ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5410137613
#yiv5410137613ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5410137613
#yiv5410137613ygrp-mlmsg select, #yiv5410137613 input, #yiv5410137613 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5410137613
#yiv5410137613ygrp-mlmsg pre, #yiv5410137613 code {font:115%
monospace;}#yiv5410137613 #yiv5410137613ygrp-mlmsg *
{line-height:1.22em;}#yiv5410137613 #yiv5410137613ygrp-mlmsg #yiv5410137613logo
{padding-bottom:10px;}#yiv5410137613 #yiv5410137613ygrp-msg p a
{font-family:Verdana;}#yiv5410137613 #yiv5410137613ygrp-msg
p#yiv5410137613attach-count span {color:#1E66AE;font-weight:700;}#yiv5410137613
#yiv5410137613ygrp-reco #yiv5410137613reco-head
{color:#ff7900;font-weight:700;}#yiv5410137613 #yiv5410137613ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5410137613 #yiv5410137613ygrp-sponsor
#yiv5410137613ov li a {font-size:130%;text-decoration:none;}#yiv5410137613
#yiv5410137613ygrp-sponsor #yiv5410137613ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5410137613
#yiv5410137613ygrp-sponsor #yiv5410137613ov ul {margin:0;padding:0 0 0
8px;}#yiv5410137613 #yiv5410137613ygrp-text
{font-family:Georgia;}#yiv5410137613 #yiv5410137613ygrp-text p {margin:0 0 1em
0;}#yiv5410137613 #yiv5410137613ygrp-text tt {font-size:120%;}#yiv5410137613
#yiv5410137613ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5410137613
