Subject Re: [firebird-support] Dual FB/IB access
Author Martijn Tonies
Hi Paul,

> I am just dipping my toe into FB and need to have access to both IB5.6 and
> FB1.5.
>
> I have installed FB1.5 on the same server (Win 2K server) as IB and set
the
> config file to use port 3060.
> I have put an entry in my services file of fb_gdb 3060/tcp.

I'm not sure if this is required - then again, I don't know how to set up
a Fb1.5 server on a different port :-)

> I have many projects on my client machine which need to be migrated over
to
> FB. They are all written in Delphi6 and use IBO to access FB. All the
> projects share a number of core units and have their own special ones. I
> think I remember seeing a message from Helen on the IBO newsgroup saying
> that I can place some IBO source file in the project directory and modify
it
> to point IBO at the new port. I'm assuming that if I do this and add

No need - you can adjust your connect string to connect to a different port.
For "Hostname" (or servername), use: server/port

eg: NT_SRVR/3060

> gds32.dll and fbclient.dll to the project directory then that project will
> connect to FB?

If you want IBO to connect to Firebird, you have to modify a value in
IB_Constants:

IB_Constants.IB_GDS32 := 'fbclient.dll'; <- do this in your initialization

If you want to connect to both IB and Fb from the same app, you're out
of luck with this solution - as IBO will load the dll only once.

> My next problem is IB manager from EMS. Has anyone succeeded in setting
it
> up for dual access? (Yes I have asked EMS but havn't had a workable reply
> so thought I would ask here as well ;-)) .

I know how to do it with Database Workbench (actually: you don't have to do
a thing - Firebird connects will use "fbclient" if it exists) :-) ... I'm
not sure if
IB Manager can connect to both by using both gds32 and fbclient... If they
haven't seperated the connection "modules", it will probably bind to gds32
OR
bind to fbclient, not both.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com