[firebird-support] Re: Firebird 4.0.0-1436 beta 1

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
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

<*> 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] Re: Firebird 4.0.0-1436 beta 1

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Newest version of what? EMS? FDAC?  Or FB4?

sources of FB4 :-)

as a working client with FB4 currently, there is RedDatabase from 
RedSoft (https://reddatabase.ru/downloads/redexpert/)

or IBExpert (https://www.ibexpert.net/downloadcenter/)
all other utilities tested to date generate compatibility errors.

-- 
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

<*> 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] Re: Firebird 4.0.0-1436 beta 1

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
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

<*> 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] Re: Firebird 4.0.0-1436 beta 1

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> 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?!

but if, of course, the development team has everything planned :-)

SET BIND OF  TIME ZONE  TO  LEGACY ;

SQL_TIMESTAMP_TZ ->SQL_TIMESTAMP

-- 
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

<*> 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] Re: Firebird 4.0.0-1436 beta 1

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> SET BIND OF  TIME ZONE  TO  LEGACY ;

for more complete information on "bind", the documentation is here

https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.set_bind.md

-- 
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

<*> 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] Re: Firebird 4.0.0-1436 beta 1

2020-03-24 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
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



  

Re: [firebird-support] Re: Firebird 4.0.0-1436 beta 1

2020-03-24 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
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

2020-03-24 Thread DougC d...@moosemail.net [firebird-support]
Please move messages about Firebird 4 (and any unreleased version) to 
developers mailing list!