Accessing the Database directly (read only)

[spec2309]

Hi,

I've read that you use Firebird for storing the movies and people data. Is it possible to read (not write!!) the data directly throught ODBC for instance?

In addition, I would like to have the possibiliy of developing more kind of plugins (i.e. not related to import/export). For instance "visualization" plugins, "reminders" plugin, "statistics" plugin,etc.

Thanks

[nostra]

I've read that you use Firebird for storing the movies and people data. Is it possible to read (not write!!) the data directly throught ODBC for instance?

Yes, you just need to have an appropriate ODBC driver installed.

In addition, I would like to have the possibiliy of developing more kind of plugins (i.e. not related to import/export). For instance "visualization" plugins, "reminders" plugin, "statistics" plugin,etc.

I planned to implement for abstract plugins engine. I can't tell when exactly it will be available, but I am pretty sure I'll do this some time.

[spec2309]

I've read that you use Firebird for storing the movies and people data. Is it possible to read (not write!!) the data directly throught ODBC for instance?

Yes, you just need to have an appropriate ODBC driver installed.

Thank you for you quick answer!    Do I need some username and password to open the database? or do I just leave them empty ?

[nostra]

It depends on driver you are using. Some of them work if you leave user name and password empty. If it does not work try these:

username: SYSDBA
password: SYSDBA

or

username: SYSDBA
password: masterkey

[cwdean]

Hello,

I'm fairly new to PVD but am really enjoying the application.  I'd like to learn more about the database and possibly extend it's functionality based on some ideas I have.  However, I can't seem to find any schema information on it.

As suggested in a previous post, I installed an ODBC driver (from here http://www.firebirdsql.org/index.php?op=files&id=odbc) but cannot seem to make a successful connection to the database.

Can you give me a brief outline on how to do this?

Thanks in advance for any help you can offer.

-CD

[nostra]

You need a client application to use the driver and connect to the database. Just google for it.

[cwdean]

You need a client application to use the driver and connect to the database. Just google for it.

With the ODBC driver installed you can still Test the connection.  Connections fail when configuring the driver to connect to the PVD database.  However, in addition to this, I have installed and attempted to connect to the database using the following clients:

• Firebird Maestro
• Interbase & Firebird Development Suite
• DB Workbench Lite
• IB Easy

All of which say they cannot connect to the database.  I get a similar message from each client, something like "unsupported on-disk structure".

Any other thoughts or suggestions?

I really appreciate the assistance.

Thanks,
CD

[nostra]

There should be an option if embedded server should be used which needs to be selected.

[cwdean]

There should be an option if embedded server should be used which needs to be selected.

Nono recommended JDBStudio as a possible Firebird client since it is free, but with it I am still getting the error.  Nowhere am I able to find a connection option to indicate an embedded server.  Which client are you using?

Thanks for your help!

[cwdean]

There should be an option if embedded server should be used which needs to be selected.

Disregard my post above (although I'd still be interested in knowing which client utility you are using).  With the trial version of Firebird Maestro I was able to find the option for indicating connecting to an embedded database, and then I was able to connect just fine.  Thanks for steering me in the right direction