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 #yi
RE: [firebird-support] Timestamp in different regions
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]
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] Timestamp in different regions
30.04.2020 17:30, 'Zoran' zoran...@gmail.com [firebird-support] wrote: > What I was hopping for is if someone with Delphi background can shed some > light on Delphi > handling this situation. Usually such situations are handled by debugging. You use debugging version of VCL and RTL, enable break on exception and look at the piece of code where the error has happened. -- 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] Timestamp in different regions
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
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-support] Timestamp in different regions
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 ___