Re: [firebird-support] Versioning Question

[Tomasz Tyrakowski]

W dniu 2012-01-03 21:58, Craig Cox pisze:
> I have written a number of Delphi applications that run on FB 1.5.  I want to 
> write new applications in, or migrate older ones to, FB 2.X.  However, in the 
> mean time I still need to be able to use and trouble shoot the legacy (FB 
> 1.5) applications.
>
> Can different versions of the Firebird client coexist on the 'client' side?

Yes. Just place a proper versions of fbclient.dll (and dependency 
libraries) in application's folder. It will take precedence over other 
versions of the client installed system-wide.

>
> Can different versions of the Firebird server coexist on the server side?

That's more tricky and the answer mostly depends on whether they're 
supposed to run in parallel, or you just need different FB setups and 
will start only one of them at a time (that's what I do on my 
development machine). In the former case, despite side-by-side 
installation of different firebird distributions (there are some hints 
how to do that on the net), you'll also have to bind different FB 
servers to different TCP ports. How to do that depends also on the 
operating system and the type of servers (Classic or SuperServer) you 
plan to install (e.g. Classic on Linux will probably require 
reconfiguration of inetd).

regards
Tomasz

-- 
__--==--__
__--== Tomasz Tyrakowski==--__
__--==SOL-SYSTEM==--__
__--== http://www.sol-system.pl ==--__
__--==--__

[firebird-support] Re: Versioning Question

[Eduardo A]

--- In firebird-support@yahoogroups.com, "Craig Cox"  wrote:
> Can different versions of the Firebird client coexist on the 'client' side?   
> 
> Can different versions of the Firebird server coexist on the server side?
Craig,

You'll probably get more details from others but, as far as I know, the 1.5 and 
2.x servers can coexist. Some 2.x servers recommend that you uninstall any 
previous version 2.x servers before installing the newer version.

In the case of the clients, that is where the problems come. Firebird 2.1 on 
are built by the Microsoft MSVC8 compiler in Visual Studio 2005. Because all 
the Firebird binaries are built to use dynamic linking, they all require 
run-time libraries. So the client DLL (FBCLIENT.DLL) requires additional DLLs 
from MS redistributables to run. And, as of now, there is no easy installer for 
the newer FBCLIENTs and their MS Redistributables for each client PC.

So not all FBCLIENT.DLLs are the same.

I've created my own "one-time" installer for all the clients which installs an 
FBCLIENT.DLL and, in case they are needed, a GDS32.DLL and calls the MS 
Redistributable MSI to install the right DLLs in the correct places so we do 
not have to distribute them with each of our apps. I am sure you can do the 
same.

Migration from 1.5.x to 2.5.x takes several steps which include the upgrading 
of the security.fdb page sizes and renaming of the database itself to 
security2.fdb.  In addition some scripts have to be run against that database. 
So it is not as simple as doing another server install and supporting both at 
the same time takes some flexibility.

The Generators (now called Sequence) are 64 bits but, if you assign the result 
to an INTEGER they are truncated to the lower 32 bits.

Of course, your mileage may vary.

-Eduardo

[firebird-support] Versioning Question

[Craig Cox]

I have written a number of Delphi applications that run on FB 1.5.  I want to 
write new applications in, or migrate older ones to, FB 2.X.  However, in the 
mean time I still need to be able to use and trouble shoot the legacy (FB 1.5) 
applications.  

Can different versions of the Firebird client coexist on the 'client' side?   

Can different versions of the Firebird server coexist on the server side?

Thanks 

[firebird-support] Update from select a long runner

[Michael Powell]

Hello,

I've got what I believe to be a long runner, but I don't know how long. I
wonder if there's any way to predict this in the Firebird environment?

UPDATE tblacqinfo ai
SET ai.vmuchannelinfoid = (select max(id) from tblvmuchannelinfo ci where
ci.vmuidx = ai.vmuidx)
WHERE EXISTS (select 1 from tblvmuchannelinfo ci where ci.vmuidx =
ai.vmuidx);

A little back story; we're putting primary and foreign keys into already
existing data tables and wanting to back fill the ids with some (somewhat)
known good data. A best guess is that this query will do the trick. It's
running, and taking upwards of 20 minutes now... So hence my concern.

Record counts are: TBLVMUCHANNELINFO = 288, TBLACQINFO = 528, where we're
expecting there to be a handful of ACQINFO records to correspond with
CHANNELINFO records, and where VMUIDX is the application glue that provides
the referential integrity context.

I haven't sent Firebird into any infinite loops have I?

Thank you,

Michael


[Non-text portions of this message have been removed]

[firebird-support] Re: Precompiling with gpre and Firebird 2,5

[cartonace]

Thanks again Frank, I will try your suggestion.


--- In firebird-support@yahoogroups.com, Frank Schlottmann-Gödde  
wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> On 31/12/11 16:18, cartonace wrote:
> 
> > Hello Frank
> > 
> > Thanks for the swift reply but the environment variables were/are
> > already set and it still prompted me for a user name and password.  I
> > think the security has been beefed up somewhere between 1.5 and 2.5
> > 
> > Thanks for the suggestion though.
> 
> Maybe you can get an answer in the developers group
> 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 
> providing some more details about what you did so far.
> 
> hth
> fsg
> 
> - -- 
> "Fascinating creatures, phoenixes, they can carry immensely heavy loads,
>  their tears have healing powers and they make highly faithful pets."
>   - J.K. Rowling
> 
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
> 
> iEYEARECAAYFAk8CukAACgkQn6XCniU5U8J+fgCeN4ggShcFRwFr7tqo0BG+Jzmb
> ZJkAnR4RwqCPfGK/2w6r6UrAIWSubcSJ
> =BjHp
> -END PGP SIGNATURE-
>

Re: [firebird-support] Firebird backup automatically

[Thomas Clarke]

>
>  On Tue, Jan 3, 2012 at 4:58 AM, Mahesh Pratihari <
> mahesh.pratih...@sonata-software.com> wrote:
>
>> **
>>
> Hi,
>
> Could you please let me know how to take the backup in firebird
> automatically like sql server maintenance plan.
>
> Thanks,
>
> Mahesh Pratihari
>
> Sonata Software Limited
>
> Phone : +91 80 3097 1527
>
> Mobile : +91 99808 37446
>
> www.sonata-software.com 
>
> Please don't print this email unless you really need to. This will
> preserve trees on our planet.
>
>
> Mahesh,

If your server is a Windows computer I have written a Firebird backup
manager program that needs some testing. You can email me at
tcla...@cybersea.biz if you would like to try the program. It schedules
backups using gbak and takes care of naming the backup files as well as
zipping them up. It also sends an email on completion. It will backup
multiple databases as well.

Let me know?

Thomas Clarke
Cyber Sea Incorporated
#6 Kingston Terrace
Flint Hall
St. Michael
Barbados BB11070

voice: (246) 234-9692
email: tcla...@cybersea.biz
web: http://cybersea.biz


[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird backup automatically

[Kjell Rilbe]

Den 2012-01-03 09:58 skrev Mahesh Pratihari såhär:
>
> Hi,
>
> Could you please let me know how to take the backup in firebird
> automatically like sql server maintenance plan.
>
> 

Just schedule a suitable bat file using Task Scheduler? You only need a 
single gbak command in the bat file - the same you run manually. You 
could use current date and/or time to name the backup file. This is mine 
(slightly modified for brevity, put all of it on a single line):

"c:\program files\firebird\firebird_2_1\bin\gbak" "D:\MyData\DB.fdb" 
"D:\MyBackups\DB %date% %time::=.%.fbk" -b -nt -password masterkey -user 
sysdba -verify -y "C:\MyBackups\Log\DB %date% %time::=.%.log" -z

It will create a gbak backup in the D:\MyBackups folder and name the 
backup file with the current timestamp. it will also write all output to 
a log file with similar name in a Log subfolder.

The %time% environment variable contains colons, which are illegal in 
filenames, so I use %time::=.% to replace those colons with dots. The 
general syntax for such substitutions is 
%variablename:chartoreplace=chartoreplacewith%.

Good luck!
Kjell

-- 
--
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64



[Non-text portions of this message have been removed]





++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
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:
http://docs.yahoo.com/info/terms/

[firebird-support] Firebird backup automatically

[Mahesh Pratihari]

Hi,

 

Could you please let me know how to take the backup in firebird
automatically like sql server maintenance plan.

 

 

 

Thanks,

Mahesh Pratihari

Sonata Software Limited 

Phone   : +91 80 3097 1527

Mobile  : +91 99808 37446

www.sonata-software.com  

 

Please don't print this email unless you really need to. This will
preserve trees on our planet.

 



[Non-text portions of this message have been removed]

Re: [firebird-support] Re: Precompiling with gpre and Firebird 2,5

[Frank Schlottmann-Gödde]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 31/12/11 16:18, cartonace wrote:

> Hello Frank
> 
> Thanks for the swift reply but the environment variables were/are
> already set and it still prompted me for a user name and password.  I
> think the security has been beefed up somewhere between 1.5 and 2.5
> 
> Thanks for the suggestion though.

Maybe you can get an answer in the developers group

https://lists.sourceforge.net/lists/listinfo/firebird-devel

providing some more details about what you did so far.

hth
fsg

- -- 
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
 their tears have healing powers and they make highly faithful pets."
  - J.K. Rowling

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk8CukAACgkQn6XCniU5U8J+fgCeN4ggShcFRwFr7tqo0BG+Jzmb
ZJkAnR4RwqCPfGK/2w6r6UrAIWSubcSJ
=BjHp
-END PGP SIGNATURE-