Opening a fbd

[John Cowan]

I am needing to open a FDB data base, cannot associate it Firebird to open it. Needing to export tables. 

[Mark Rotteveel]

On 14-08-2021 09:29, John Cowan wrote:
> I am needing to open a FDB data base, cannot associate it Firebird to
> open it. Needing to export tables.

Firebird is a database management system, it is not a tool like Excel,
so associating FDB file extensions will get you nowhere as that is not
how it works.

You need to install Firebird server, run the server process, and then
connect to it using a tool like DBeaver, FlameRobin, IB Expert, or others.

And that assumes the FDB file is compatible with the Firebird server
version you installed. Having a transportable backup would avoid some
compatibility issues.

Mark
--
Mark Rotteveel

[angli...@gmail.com]

Thank you for getting back to me, that seems over complicated just to open the tables for export. I can easily open sdf (sequel) DBISAM tables and others. I have installed Firebird Server, but it just sits on the task bar unless I click on it, then get, see below signature.

I have attached a zipped copy of the data base I need to open with the original question.

Any further help appreciated

Best wishes and stay safe

John Cowan

Partner

for Anglia EPOS

Email to mobile devices john.ti...@live.co.uk

Phone: 01328 829607 Mobile 07957 355615

Communication is everything.  The world is going mobile

x  Protect our environment - save paper - do you need to print this email?

Confidential

This e-mail and any files transmitted with it are the property of Anglia EPOS or their agents, customers and/or suppliers.

They are confidential, and intended solely for the use of the individual or entity to whom this e-mail is addressed and

are subject to Anglia EPOS standard terms and conditions. It is in your interest to see and read these terms and conditions.

 

If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message and any attachments from your computer.

Any use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited by any individual

or entity other than the addressee.

The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

 

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/7f2f5d95-075f-4c96-f874-a50d9436b852%40lawinegevaar.nl.

[Mark Rotteveel]

On 14-08-2021 10:15, angli...@gmail.com wrote:
> Thank you for getting back to me, that seems over complicated just to
> open the tables for export. I can easily open sdf (sequel) DBISAM tables
> and others. I have installed Firebird Server, but it just sits on the
> task bar unless I click on it, then get, see below signature.
>
> I have attached a zipped copy of the data base I need to open with the
> original question.

This is simply not how Firebird works. Would you expect the same for a
SQL Server, PostgreSQL or Oracle database? To repeat, you need to use a
query tool like DBeaver, FlameRobin, IB Expert, etc. to connect to the
database through the Firebird server process to be able to query and
export the data.

Mark
--
Mark Rotteveel

[angli...@gmail.com]

Thank you again for the reply Mark, though I do not have this problem opening FoxPro, DBISAM, Sequel data bases etc. but this is how it works then fair enough. However, with Firebird running and DBeaver it still won't connect. I have put the question to DBeaver's support but not heard anything back as yet. Please see screen dump attached for the error, cannot find the error log in Firebird. Any help appreciated as trying to avoid having to do most of the data entry for the new POS system manually, if at all possible, and getting all the product follow on information from their current system. I will have to ask them to list this information for each product if cannot get the table export needed.
This is getting time sensitive now so any help will be greatly appreciated.

Best wishes and stay safe
John Cowan

For Anglia EPOS
Terms & conditions apply

Email to mobile devices john.ti...@live.co.uk

Communication is everything. The world is going mobile.

The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

-----Original Message-----
From: firebird...@googlegroups.com <firebird...@googlegroups.com> On Behalf Of Mark Rotteveel
Sent: 14 August 2021 10:21
To: firebird...@googlegroups.com
Subject: Re: [firebird-support] Opening a fbd

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/db4ddf1f-2670-3f88-7344-c0e7c1ed820c%40lawinegevaar.nl.

[Mark Rotteveel]

On 2021-08-15 19:05, angli...@gmail.com wrote:
> Thank you again for the reply Mark, though I do not have this problem
> opening FoxPro, DBISAM, Sequel data bases etc. but this is how it
> works then fair enough. However, with Firebird running and DBeaver it
> still won't connect. I have put the question to DBeaver's support but
> not heard anything back as yet. Please see screen dump attached for
> the error, cannot find the error log in Firebird. Any help appreciated
> as trying to avoid having to do most of the data entry for the new POS
> system manually, if at all possible, and getting all the product
> follow on information from their current system. I will have to ask
> them to list this information for each product if cannot get the table
> export needed.
> This is getting time sensitive now so any help will be greatly
> appreciated.

You need to check firebird.log in the installation directory of
Firebird. That assumes you're running it as a service, or - if you're
running it as an application - that you have sufficient write access to
C:\Program Files\Firebird\... (i.e. using UAC). If not, you need to look
in the VirtualStore folder of your user profile.

In any case, as to the error, see
https://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html#error-occurred-during-login-please-check-server-firebird.log-for-details-335545106
(Jaybird is the driver used by DBeaver to connect).

Likely this error means that you have configured AuthServer =
Legacy_Auth in firebird.conf, while Jaybird 4 defaults to Srp256,Srp.
You either need to specify connection property authPlugins=Legacy_Auth
in DBeaver, or you need to change the Firebird configuration. All this
also assumes that you actually have a user created to connect.

However, if you're currently running Firebird as an application from
C:\Program Files\... and it doesn't have sufficient rights to write the
firebird.log in that location, then Firebird is unlikely to work
properly. Either install and run it as a service, or make sure you
install it in a location outside of C:\Program Files.

Mark