Recent

Author Topic: Lazarus 1.6 & Firebird 3.0  (Read 17011 times)

DeBritto

  • Jr. Member
  • **
  • Posts: 68
Lazarus 1.6 & Firebird 3.0
« on: June 24, 2016, 05:39:58 am »
Hi folks,
Someone has some information about Lazarus 1.6+FPC 3.0 running Firebird 3.0? I installed FB3 today and run my application but it doesn't connect to database. I'm using the native SQLdb component. Someone of you have information about the next Lazarus version or beta versions?

LacaK

  • Hero Member
  • *****
  • Posts: 691
Re: Lazarus 1.6 & Firebird 3.0
« Reply #1 on: June 24, 2016, 08:05:11 am »
And can you connect to FB3 with any 3rd party tool ?

I have used FB3 Embeded on Windows and it seems to me, that it works also with older versions of FPC and Lazarus

talorigomat

  • Jr. Member
  • **
  • Posts: 96
Re: Lazarus 1.6 & Firebird 3.0
« Reply #2 on: June 25, 2016, 08:08:02 am »
I'm having the same problem.  When I connect using third party tools eg: dbworkbench it is okay.  When I try connecting with SQLDB it tells me my username and password are not defined.
Lazarus 1.8.0Rc4, Windows 10

Zoran

  • Hero Member
  • *****
  • Posts: 1829
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: Lazarus 1.6 & Firebird 3.0
« Reply #3 on: June 25, 2016, 09:46:35 am »

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: Lazarus 1.6 & Firebird 3.0
« Reply #4 on: June 25, 2016, 09:52:47 am »
... but it doesn't connect to database.
Both TIBConnection and TSQLConnector work fine for me with Firebird 3.0 and Lazarus 1.6.

What error are you getting?
What username/password did you use (in 3.0 masterke might not work, note the absence of the y).

talorigomat

  • Jr. Member
  • **
  • Posts: 96
Re: Lazarus 1.6 & Firebird 3.0
« Reply #5 on: June 25, 2016, 04:09:17 pm »
I'm using user  name as sysdba and password as master key.   I had uninstalled firebird 2.5 before installing vs3
Lazarus 1.8.0Rc4, Windows 10

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: Lazarus 1.6 & Firebird 3.0
« Reply #6 on: June 25, 2016, 04:35:30 pm »
I'm using user  name as sysdba and password as master key.   I had uninstalled firebird 2.5 before installing vs3
It's SYSDBA (all caps) and masterkey (without a space).

You didn't mention what error you got.

talorigomat

  • Jr. Member
  • **
  • Posts: 96
Re: Lazarus 1.6 & Firebird 3.0
« Reply #7 on: June 25, 2016, 04:55:54 pm »
The error I'm getting DoInternalConnect: 'your user name and password are not defined.  Ask your administrator to set up a Firebird login.   I'm using user name as SYSDBA  and password masterkey.   I had uninstalled Firebird 2.5 before installing Firebird 3
Lazarus 1.8.0Rc4, Windows 10

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: Lazarus 1.6 & Firebird 3.0
« Reply #8 on: June 25, 2016, 05:58:00 pm »
Did you skip the "enter new password" screen when installing Firebird 3.0?
(you need to, to make sure the password and user is default)

But if you can connect with the same user/password via dbworkbench that's strange.
(or dbworkbench uses it's own embedded driver)

Also... you can't connect to databases made in previous Firebird versions (yet). Did you create the DB with dbworkbench ? Can you check in dbworkbench what the ODS is of the DB created?

talorigomat

  • Jr. Member
  • **
  • Posts: 96
Re: Lazarus 1.6 & Firebird 3.0
« Reply #9 on: June 25, 2016, 06:00:57 pm »
Solved.  I uninstalled and then reinstalled firebird 3 (did it twice).  During setup when I typed the password in for SYSDBA as masterkey  I get an error when I try to connect in Lazarus. If I click though the setup without inputting the password as masterkey then I connect without a problem in Lazarus. 

Lazarus 1.8.0Rc4, Windows 10

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: Lazarus 1.6 & Firebird 3.0
« Reply #10 on: June 25, 2016, 06:08:32 pm »
During setup when I typed the password in for SYSDBA as masterkey  I get an error when I try to connect in Lazarus. If I click though the setup without inputting the password as masterkey then I connect without a problem in Lazarus.
Strange. The first time I installed Firebird 3.0 I skipped the password page and it worked for me (and now for you too). But I had to try it, now, with putting in masterkey. So... just uninstalled it, removed the Firebird directory from program files (which was not entirely deleted) and installed again, inputting masterkey (with the y on the end). And... still all is wel with connecting to Firebird 3.0 from Lazarus. So I can't imagine what went wrong with your installation the first time... but it's solved now.

talorigomat

  • Jr. Member
  • **
  • Posts: 96
Re: Lazarus 1.6 & Firebird 3.0
« Reply #11 on: June 25, 2016, 06:40:32 pm »
It's a mystery to me too.  Thanks for the help
Lazarus 1.8.0Rc4, Windows 10

laguna

  • Sr. Member
  • ****
  • Posts: 323
Re: Lazarus 1.6 & Firebird 3.0
« Reply #12 on: June 29, 2016, 09:15:50 am »
How can I use the Embedded version?
Which components can be used, the IBX are fine?
Thank you all.

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: Lazarus 1.6 & Firebird 3.0
« Reply #13 on: June 29, 2016, 10:25:29 am »
How can I use the Embedded version?
For Firebird 3.0:
You can download the "Zip kit for manual/custom installs" and extract all files to you program directory.
(note: download the correct bitness 32/64bit the same as your Lazarus version)
It will use the fbclient.dll directly and see it needs to be the embedded version.
I haven't found a way to copy the files to a subdirectory because they removed the RootDirectory option.

For Firebird 2.5:
You can download the "Embedded, separate download, zip kit." and extract it to your program directory.

Please note that for testing purposes the server version is easier. You can distribute your working program with embeded later without change (if you keep the connect-string configurable).

Quote
Which components can be used, the IBX are fine?
The standard SQLdb from Lazarus, IBX and ZeosLib all should work fine.

DeBritto

  • Jr. Member
  • **
  • Posts: 68
Re: Lazarus 1.6 & Firebird 3.0
« Reply #14 on: June 30, 2016, 02:41:33 am »
Hi Folks,
After many tentatives it's working! Firebird 3.0+Lazarus 1.6 (sqldb)+free pascal 3.0.
I really dont't understod what happened. I installed FB3 many times, in the beginnig I was receiving some erros and Lazarus was crashing. But now, its working fine and I did not changed nothing in my app.
« Last Edit: June 30, 2016, 08:23:38 pm by DeBritto »

 

TinyPortal © 2005-2018