Subject | Re: [firebird-support] FB 3.0 |
---|---|
Author | Alan J Davies |
Post date | 2015-11-10T08:11:45Z |
Hi, this is really off-topic here but these pointers will help.
IBX components will show with way red lines underneath - everything from
IBDatabase to IBQuery to IBStoredProc.
Use Firedac, it works very well and if you are careful you can change
all your e.g. IBqry1, IBqry2 to FBqry1, FBqry2 .... do this by selecting
View as Text in your datamodule and using search/replace. Unfortunately
the supposed tool for automating this does not work so you could also
drop an FBqry on the form and change the name to an exiting IBqry then
delete the IBqry.
You also need a Firedac TFDConnection, TFDtransaction,
TFDPhysFBDriverLink and FDGUIxWaitCursor.
You will need a FDConnectionDefs ini file in a path accessible to your
program, try the exe folder. Copy the existing sample one and amend it.
In there you need to set up this:
[newtown_settings] // your own such as myaccounts_settings
DriverID=FB
VendorLib = 'C:\Program Files (x86)\Firebird\Firebird_2_5\bin\fbclient.dll'
Database=192.168.1.104:c:\apps\newtown\orders.fdb
User_Name=sysdba
Password=*******
There is a lot of work involved if you have numerous queries and sps.
The Embarcadero docwikis are helpful but don't go far enough.
Good luck.
Alan J Davies
Aldis
On 10/11/2015 07:41, 'Tiberiu Horvath' tiberiu_horvath@...
[firebird-support] wrote:
IBX components will show with way red lines underneath - everything from
IBDatabase to IBQuery to IBStoredProc.
Use Firedac, it works very well and if you are careful you can change
all your e.g. IBqry1, IBqry2 to FBqry1, FBqry2 .... do this by selecting
View as Text in your datamodule and using search/replace. Unfortunately
the supposed tool for automating this does not work so you could also
drop an FBqry on the form and change the name to an exiting IBqry then
delete the IBqry.
You also need a Firedac TFDConnection, TFDtransaction,
TFDPhysFBDriverLink and FDGUIxWaitCursor.
You will need a FDConnectionDefs ini file in a path accessible to your
program, try the exe folder. Copy the existing sample one and amend it.
In there you need to set up this:
[newtown_settings] // your own such as myaccounts_settings
DriverID=FB
VendorLib = 'C:\Program Files (x86)\Firebird\Firebird_2_5\bin\fbclient.dll'
Database=192.168.1.104:c:\apps\newtown\orders.fdb
User_Name=sysdba
Password=*******
There is a lot of work involved if you have numerous queries and sps.
The Embarcadero docwikis are helpful but don't go far enough.
Good luck.
Alan J Davies
Aldis
On 10/11/2015 07:41, 'Tiberiu Horvath' tiberiu_horvath@...
[firebird-support] wrote:
> Hi all,
> We use FireBird since 1.0 and develop programs with Delphi (recently
> upgraded to D10 Seattle). We use plain IBX components to connect to the
> FB server in a few big accounting programs. Tried to play with FB3.0 RC1
> and installed it on port 3051 for testing, alongside FireBird 2.5.4 on
> port 3050.
> Our problem is that Delphi (the IDE) connects to the new server / ODS
> database, also IBExpert connects to the new server / database but the
> programs, on runtime, does not. Can we specify somewhere (params in
> TIBDatabase / TIBTransaction) the path / file of the client dll for
> Firebird / Interbase ? Probably the app cannot load the proper dll
> (FB3.0) on statup.
> Anybody using Delphi and IBX could connect to FB3.0 with their programs
> ? Are these compatible ? Is there something we could do ? Upgrading to
> FireDAC or IBO is our last option.
> Thank you,
> Tiberiu
> PS backup and restore from ODS 11.x to OSD 12.0 is not a problem, since
> we could install both versions (2.5.4 and 3.0) and automate the process.
>
>