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).