Recent

Author Topic: A problem with Firebird Embedded 2.5  (Read 2090 times)

pascal111

  • Sr. Member
  • ****
  • Posts: 423
  • Un trabajo en equipo para programas serias.
A problem with Firebird Embedded 2.5
« on: July 06, 2022, 06:40:38 pm »
I was following tutorials of next links:

https://wiki.freepascal.org/Lazarus_Database_Overview

https://wiki.freepascal.org/SQLdb_Tutorial0

https://wiki.freepascal.org/SQLdb_Tutorial1

I was trying apply the example, but I found an error that I don't understand like in next image. I tried to use  Firebird Embedded 2.5 and extracted its demanded files as it is explained in https://wiki.freepascal.org/SQLdb_Tutorial0 but I still has a problem. I have poor knowledge in databases, I know the basics only.

https://i.postimg.cc/3NV1PyvX/pas1-Untitled-1-copy.jpg
La chose par la chose est rappelé.

af0815

  • Hero Member
  • *****
  • Posts: 1291
Re: A problem with Firebird Embedded 2.5
« Reply #1 on: July 06, 2022, 06:45:57 pm »
The answer is in the picture.

The DB found is Version 13.0. But the version of DB-driver supported by Lazarus can only Version 11.2.


Is the db created by Lazarus or with a external tool ? (Or copied from samples folder of the firebird installation)

« Last Edit: July 06, 2022, 06:49:48 pm by af0815 »
regards
Andreas

Thaddy

  • Hero Member
  • *****
  • Posts: 14371
  • Sensorship about opinions does not belong here.
Re: A problem with Firebird Embedded 2.5
« Reply #2 on: July 06, 2022, 06:54:25 pm »
Just do not use Firebird. >:D Almost nobody uses it and should not use it, except from some old Delphi programmers who insist on it.
It is not a mainstream format and FPC supports almost all mainstream databases.
« Last Edit: July 06, 2022, 06:57:44 pm by Thaddy »
Object Pascal programmers should get rid of their "component fetish" especially with the non-visuals.

pascal111

  • Sr. Member
  • ****
  • Posts: 423
  • Un trabajo en equipo para programas serias.
Re: A problem with Firebird Embedded 2.5
« Reply #3 on: July 06, 2022, 06:56:10 pm »
The answer is in the picture.

The DB found is Version 13.0. But the version of DB-driver supported by Lazarus can only Version 11.2.


Is the db created by Lazarus or with a external tool ? (Or copied from samples folder of the firebird installation)

The DB file is created by Firebird server last version. How we can solve this problem?
La chose par la chose est rappelé.

pascal111

  • Sr. Member
  • ****
  • Posts: 423
  • Un trabajo en equipo para programas serias.
Re: A problem with Firebird Embedded 2.5
« Reply #4 on: July 06, 2022, 06:57:16 pm »
Just do not use firebird. >:D

The tutorial said the fastest way for DB is firebird!
La chose par la chose est rappelé.

Thaddy

  • Hero Member
  • *****
  • Posts: 14371
  • Sensorship about opinions does not belong here.
Re: A problem with Firebird Embedded 2.5
« Reply #5 on: July 06, 2022, 07:00:18 pm »
The tutorial said the fastest way for DB is firebird!
That is a bad advice.. Ignore it. Where is that manual? Time to burn it.
If I have the time I will adapt those entries, btw.
« Last Edit: July 06, 2022, 07:03:22 pm by Thaddy »
Object Pascal programmers should get rid of their "component fetish" especially with the non-visuals.

pascal111

  • Sr. Member
  • ****
  • Posts: 423
  • Un trabajo en equipo para programas serias.
Re: A problem with Firebird Embedded 2.5
« Reply #6 on: July 06, 2022, 07:06:09 pm »
The tutorial said the fastest way for DB is firebird!
That is a bad advice.. Ignore it. Where is that manual? Time to burn it.
If I have the time I will adapt those entries, btw.

https://wiki.freepascal.org/SQLdb_Tutorial0
Quote
If you want to get up and running quickly, I'd suggest installing the Firebird server and example database as described below.
La chose par la chose est rappelé.

Handoko

  • Hero Member
  • *****
  • Posts: 5152
  • My goal: build my own game engine using Lazarus
Re: A problem with Firebird Embedded 2.5
« Reply #7 on: July 06, 2022, 07:30:50 pm »
English is not my native language but I'm sure:

Quickly <> Fastest

 ;D

pascal111

  • Sr. Member
  • ****
  • Posts: 423
  • Un trabajo en equipo para programas serias.
Re: A problem with Firebird Embedded 2.5
« Reply #8 on: July 06, 2022, 07:41:30 pm »
English is not my native language but I'm sure:

Quickly <> Fastest

 ;D

Look yourself in English-Arabic dictionary:

https://i.postimg.cc/L8DY5J92/fast-Untitled-1-copy.jpg

https://i.postimg.cc/fbgV71SP/quick-Untitled-2-copy.jpg
La chose par la chose est rappelé.

alpine

  • Hero Member
  • *****
  • Posts: 1064
Re: A problem with Firebird Embedded 2.5
« Reply #9 on: July 06, 2022, 07:50:08 pm »
Qickly <> Fastest
Definitely! ;)
"I'm sorry Dave, I'm afraid I can't do that."
—HAL 9000

pascal111

  • Sr. Member
  • ****
  • Posts: 423
  • Un trabajo en equipo para programas serias.
Re: A problem with Firebird Embedded 2.5
« Reply #10 on: July 06, 2022, 07:52:34 pm »
Qickly <> Fastest
Definitely! ;)

Prove that (if you can  >:D)!
La chose par la chose est rappelé.

rvk

  • Hero Member
  • *****
  • Posts: 6163
Re: A problem with Firebird Embedded 2.5
« Reply #11 on: July 06, 2022, 08:35:27 pm »
The DB file is created by Firebird server last version. How we can solve this problem?
Don't listen to Thaddy. It's his personal opinion.

I've worked with Firebird for over 18 years (since version 1.5 and Interbase before that) and love it and have absolutely no problems with it.

The problem from you starting post is that you have an existing DB made in Firebird 3 and you want to access it using Firebird 2.5.
That's not possible.
Install Firebird 3.0 or use a database which is for 2.5.

Where does this database come from?

BTW. Lazarus can do Firebird 3.0 perfectly fine.
What components are your using.
You could think about using IBX for Lazarus (special for Firebird).
But I'm sure the default components can handle it too (because the drivers haven't changed).

But you can't access a 3.0 database with Firebird 2.5. That's a problem with any database you will use.
« Last Edit: July 06, 2022, 08:37:53 pm by rvk »

Thaddy

  • Hero Member
  • *****
  • Posts: 14371
  • Sensorship about opinions does not belong here.
Re: A problem with Firebird Embedded 2.5
« Reply #12 on: July 06, 2022, 08:55:22 pm »
English is not my native language but I'm sure:

Quickly <> Fastest

 ;D
Correct. Use something that can be maintained from the start, not something that gives your customer headaches if something happens to you.
ALWAYS use industry standards. Firebird is not one of those.....
Object Pascal programmers should get rid of their "component fetish" especially with the non-visuals.

pascal111

  • Sr. Member
  • ****
  • Posts: 423
  • Un trabajo en equipo para programas serias.
Re: A problem with Firebird Embedded 2.5
« Reply #13 on: July 06, 2022, 08:59:28 pm »
The DB file is created by Firebird server last version. How we can solve this problem?
Don't listen to Thaddy. It's his personal opinion.

I've worked with Firebird for over 18 years (since version 1.5 and Interbase before that) and love it and have absolutely no problems with it.

The problem from you starting post is that you have an existing DB made in Firebird 3 and you want to access it using Firebird 2.5.
That's not possible.
Install Firebird 3.0 or use a database which is for 2.5.

Where does this database come from?

BTW. Lazarus can do Firebird 3.0 perfectly fine.
What components are your using.
You could think about using IBX for Lazarus (special for Firebird).
But I'm sure the default components can handle it too (because the drivers haven't changed).

But you can't access a 3.0 database with Firebird 2.5. That's a problem with any database you will use.

Nice! I'll try what you said tomorrow because I'm tired now. I wasted another day without reaching to an effective learning for Lazarus.

By the way, for our other friends who care about the matter of "Qickly <> Fastest" I'll say that it'll be so difficult to prove that with English except if you are an expert in English. Many times clarifying the differences between similar English words by English itself will be an obscure work, that you'll reach to a no so good clear meanings, or you lack kind of Arabization of the meanings, and it's - according to my experience in English - some difficult in English itself for some essential attributes of English itself that it's not so free language in its ways of expressing like Arabic. When we speak English, we are together in closed room in this world, but when we speak Arabic, we bring our works to be shown outside to the reality.
« Last Edit: July 06, 2022, 09:04:53 pm by pascal111 »
La chose par la chose est rappelé.

pascal111

  • Sr. Member
  • ****
  • Posts: 423
  • Un trabajo en equipo para programas serias.
Re: A problem with Firebird Embedded 2.5
« Reply #14 on: July 06, 2022, 09:02:22 pm »
Correct. Use something that can be maintained from the start, not something that gives your customer headaches if something happens to you.
ALWAYS use industry standards. Firebird is not one of those.....

I think Pascal planned not to make me reach high level in Lazarus in Egypt, maybe if I came to USA he will leave me to learn and do more.
La chose par la chose est rappelé.

 

TinyPortal © 2005-2018