SCOPA Grant 2000
An Exploration of Interbase, an Open Source Database
Karen M. Reardon
Manager of Workstation Support for the Library Systems Office
&
Brian M. Kupiec
Systems Officer for the Beinecke Rare Book & Manuscript Library
Microsoft Internet Information Server www.microsoft.com
Apache Web Server httpd.apache.org/
Sun Chili!Soft ASP www.chilisoft.com/
Version 3.4 Trial ($500 US)
FireBird Interbase 6
An open source version of Interbase: from the IBPhoenix Project at www.ibphoenix.com
FastTextSearch/IB
Full text search engine for IB from Soft Lab at www.softcomplete.com (Ukraine)
Shareware ($50 US).
Easysoft ODBC for InterBase 6
An ODBC driver for IB from www.easysoft.com (Nick Gorham USA)
($100 US)
Connection string example:
conn.open "Driver={Easysoft IB6 ODBC};Pwd=vaporware;Uid=wwwuser;database=localhost:d:\ib_db\libroni\Libroni.gdb"
conn.open "Driver={Easysoft IB6 ODBC};Pwd=vaporware;Uid=wwwuser;database=localhost:d:\ib_db\photoneg\photoneg.gdb"
XTG Systems InterBase 6 ODBC Driver
An ODBC freeware driver for IB from XTG Systems at www.xtgsystems.com (Czech Republic)
(free)
Connection string example:
conn.open "Provider=MSDASQL.1;UID=wwwuser;PWD=vaporware;Data Source=libroniXTG"
conn.open "Provider=MSDASQL.1;UID=wwwuser;PWD=vaporware;Data Source=photonegXTG"
InterSolv InterBase ODBC Driver
ODBC driver that came with InterBase5 from Borland/InterSolv
(not available unbundled)
Connection string example:
conn.open "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};
UID=wwwuser;PWD=vaporware;db=localhost:d:\ib_db\libroni\Libroni.gdb"
conn.open "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};
UID=wwwuser;PWD=vaporware;db=localhost:d:\ib_db\photoneg\photoneg.gdb"
Delphi 5 & InterBase Express Controls (client app)
IBDatabase control database: 130.132.81.120:d:\ib_db\libroni\libroni.gdb
Configuration A:
URL for the IIS based Marinetti Libroni InterBase prototype:
http://130.132.81.120/marinettilibroni/BEGINSRCH.asp
Configuration B:
URL for the Apache/Chili!Soft based Marinetti Libroni InterBase prototype:
http://130.132.81.120:6900/wwwdata/marinettilibroni/beginsrch.asp
All data was migrated from its original location in MSSQL7 to IB6 using the Delphi5 Database Desktop tool (Copy function).