Demo Databases (FireDAC)

From RAD Studio
Jump to: navigation, search

Go Up to Getting Started (FireDAC)


This topic describes how to install the FireDAC demo databases.

Generalities

FireDAC uses the Northwind as a demo database. The SQLite and MS Access demo databases are preinstalled and do not require any additional configuration. For other DBMS, you have to set up the connection and create a database. FireDAC contains SQL scripts, CSV data files, and BAT files. The demo database may be created manually at any time.

Prerequisites

  • You should have an existing database and user account.
  • SQLite - the installer installs a ready-to-use database file at C:\Users\Public\Documents\Embarcadero\Studio\18.0\Samples\Data\fddemo.sdb.
  • Access database - the installer installs a ready-to-use database file at C:\Users\Public\Documents\Embarcadero\Studio\18.0\Samples\Data\fddemo.mdb.
  • SQL Server 2000 - the Northwind DB installation may be optional. Since it is part of the SQL Server 2000 distribution, it may be downloaded separately or it may be already installed.

Build Demo DB

To build a demo database, perform the following steps:

DBMS Sample connection definition Connection definition name
Advantage Database [ADS_Demo]

DriverID=ADS

ServerTypes=2

Database=\\DA\ADS_DB\ADDEMO.ADD

User_Name=adssys

ADS_Demo
IBM DB2 Server [DB2_Demo]

DriverID=DB2

Alias=addemo

User_Name=db2admin

DB2_Demo
Firebird [FB_Demo]

DriverID=FB

Database=E:\Firebird\ADDEMO.FDB

User_Name=sysdba

FB_Demo
Informix [Infx_Demo]

DriverID=Infx

Server=ol_informix1170

Database=sysuser

User_Name=informix

Infx_Demo
InterBase [IB_Demo]

DriverID=IB

Database=E:\Interbase\ADDEMO.GDB

User_Name=sysdba

IB_Demo
Microsoft Access Database [Access_Demo]

DriverID=MSAcc

Database=(RAD Studio Demos)\Data\fddemo.mdb

Access_Demo
Microsoft SQL Server [MSSQL_Demo]

DriverID=MSSQL

Server=127.0.0.1

Database=Northwind

User_Name=sa

MSSQL_Demo
MySQL Server [MySQL_Demo]

DriverID=MySQL

Server=127.0.0.1

Database=addemo

User_Name=root

MySQL_Demo
Oracle Server [Oracle_Demo]

DriverID=Ora

Database=ORA_920_APP

User_Name=ADDemo

Oracle_Demo
PostgreSQL [PG_Demo]

DriverID=PG

Server=127.0.0.1

Database=addemo

User_Name=ad

PG_Demo
SQLite database [SQLite_Demo]

DriverID=SQLite

Database=(RAD Studio Demos)\Data\fddemo.sdb

SQLite_Demo
Sybase SQL Anywhere [ASA_Demo]

DriverID=ASA

Server=addemo_asa11

Database=addemo_asa11

User_Name=dba

ASA_Demo
Teradata Database [TData_Demo]

DriverID=TData

Server=192.168.43.140

User_Name=dbc

Password=dbc

TData_Demo
  • Go to the C:\Users\Public\Documents\Embarcadero\Studio\18.0\Samples\Object Pascal\Database\FireDAC\Bin folder.
  • SQL Server - to disable the Northwind DB installation, open createMSSQL.bat and replace True with False. For the SQL Server 2000, replace MSSQL with MSSQL2000.
  • Run create<your DBMS>.bat.

See Also