Point and click queries.

            Any data source.

                        Any computer.

                                    Data server.

                                                Free.


        FireBird Database Server
                ( Please scroll down. )

Disclaimer

Brand names are addressed only as a service to CoreReader users. See the source specifics page for details.

To add to these notes or to add your favorite data source, see instructions on the source specifics page.

Source

Reinier Olislagers of The Netherlands.

Running With FireBird

Also, refer to the InterBase notes. Firebird is an open source product that was spun off from InterBase. The InterBase owners later closed the code. By now, there may be lots of differences between the two, but the basics have not changed.

Unfortunately, extraneous non-standard characters are allowed in object names. That problem can be circumvented through the use of CoreReader's configuration parameters. It appears that perhaps quotation characters should be used as delimiters instead of the standard apostrophe.

I have not been able to get any of the data sockets to work in the test environment. Maybe it's my fault or maybe it's because they're so new. After all, the MySql people did not have a reliable data socket for a couple of years after they announced themselves.

The data socket that was reportedly used to connect CoreReader to Firebird version 1 was the XTG ODBC driver (beta 16).

Many data sockets may be used to connect to InterBase and to Firebird. Three of the free ones are the XTG driver, the ODBC/JDBC (Starkey) driver, and the IBPhoenix driver.

These data sockets use non-standard connection parameters such as the DBNAME instead of DATABASE. Therefore, a connection string must be used instead of entering parameters into the boxes.

A connection string using the IBPhoenix data socket might look something like this:
DRIVER={Firebird/Interbase(r) Driver}; DBNAME=localhost:C:\Firebird\EMPLOYEE.FDB; UID=SYSDBA; PWD=masterkey
(Be sure to remove the spaces after the three semi-colons.)

A connection string using the XTG data socket might look something like this:
DRIVER={XTG Systems InterBase6 ODBC driver}; DB=127.0.0.1:C:\Firebird\EMPLOYEE.FDB; UID=SYSDBA; PWD=masterkey
(Be sure to remove the spaces after the three semi-colons.)

This web site is maintained with Notepad.

Copyright 2001 - 2010 John Ragan.