Page 1 of 1
Unidac and FireBird
Posted: Wed 31 Oct 2012 18:19
by FerCastro
Hello
I am trying to run my application under Windows 2003 Server. I have the release 2.5.0.26075 Firebird 2.5 of the FB Server running as a service.
Simply I can not stablish the connection to the FB service, althoug the parameters are correct. I have not the service running on my laptop, i must say.
Is something a I missing?
Thanks and best regards
Fernando Castro
México, D.F.
Re: Unidac and FireBird
Posted: Thu 01 Nov 2012 09:18
by AndreyZ
Hello,
Here is a code example that demonstrates connecting to a Firebird database using UniDAC:
Code: Select all
procedure TForm1.Button1Click(Sender: TObject);
begin
UniConnection1.ProviderName := 'InterBase';
UniConnection1.Server := 'localhost'; // you can leave the Server property blank. In this case, the local protocol will be used instead of TCP.
UniConnection1.Username := 'sysdba';
UniConnection1.Password := 'masterkey';
UniConnection1.Database := 'database_path'; // for example, C:\my.fdb
UniConnection1.SpecificOptions.Values['ClientLibrary'] := 'fbclient.dll';
UniConnection1.LoginPrompt := False;
UniConnection1.Open;
end;
If you cannot connect to your Firebird database using this code, please specify the exact error that occurs while executing it.
Re: Unidac and FireBird
Posted: Fri 02 Nov 2012 03:15
by FerCastro
Dear AndreyZ,
Thanks for your help, it's already solved.
Re: Unidac and FireBird
Posted: Fri 02 Nov 2012 08:35
by AndreyZ
It is good to see that the problem was solved. If any other questions come up, please contact us.
Re: Unidac and FireBird
Posted: Tue 23 Jun 2015 20:49
by tromani
I tryed your code
so i have got:
INTERBASE is not licensed
but i'am using firebird, not interbase
Re: Unidac and FireBird
Posted: Fri 26 Jun 2015 10:21
by ViktorV
tromani wrote:I tryed your code
so i have got:
INTERBASE is not licensed
but i'am using firebird, not interbase
The error occurs when you are trying to connect to Firebird using non-licensed Interbase client library. If the ClientLibrary property of the TUniConnection components is set to an empty string, then UniDAC itself will search for the client library - and, probably, load the Interbase client library.
Please make sure you are using the Firebird client library when connecting to Firebird. For this, write the full path to the Firebird client library in the ClientLibrary property of the TUniConnection component. For example:
Code: Select all
UniConnection1.SpecificOptions.Values['ClientLibrary'] := 'c:\Firebird\fbclient.dll';
Re: Unidac and FireBird
Posted: Sat 27 Jun 2015 16:26
by tromani
no
library is set like you post
Re: Unidac and FireBird
Posted: Fri 03 Jul 2015 10:16
by ViktorV
This error may occur when Firebird and InterBase services are running on the computer simultaneously (the InterBase service is installed by default when installing RAD Studio). Your application may attempt to connect to InterBase, since the connection port is the same for InterBase and Firebird by default - 3050
Please check whether the InterBase service is running. If it is, stop the InterBase service and check whether the error is still reproduced.
Note: to prevent the InterBase service to start automatically, you can select the Disabled value for the Start Type option in the InterBase service settings.