Connect to Interbase or Firebird Server (AnyDAC)

From RemObjects Software

Jump to: navigation, search

This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.


Supported versions

Th AnyDAC native driver supports Interbase server version 7.5 and higher and Firebird server version 1.5 and higher. AnyDAC distinguishes these DBMS brands and adjusts its own behaviour to the connected database. It does not oficially support Jaffil.


Client software

AnyDAC requires the following client software to be installed on the workstation:

  • GDS32.DLL library to connect to the Interbase server.
  • FBCLIENT.DLL library to connect to the Firebird server.
  • FBEMBED.DLL library to work with database using the Firebird Embedded server. You can download it from here. You can find the description here.

A DLL must be copied either into a folder in the PATH or into the EXE folder.

Do not use FBCLIENT to connect to Interbase or GDS32 to connect to Firebird, otherwise the application will raise "strange" exceptions!


Connection definition parameters

DriverID=IB

Parameter

Description

Example value

Database

The name of the database to attach. The value may be either:

  • database file path;
  • full database path, including server address.
  • C:\ib\ADDEMO_IB2007.IB
  • 127.0.0.1:C:\ib\ADDEMO_IB2007.IB
  • \\MySrv\C:\ib\ADDEMO_IB2007.IB

UserName

The user name.

sysdba

Password

The user password.

masterkey

CharacterSet

The character set to use.

WIN1251

Protocol

The protocol used to connect to DB server. It may be one of the following values:

  • Local. Connect to locally running server or to embedded server.
  • NetBEUI. Connect using Microsoft NetBIOS protocol.
  • SPX. Connect using Novel SPX protocol.
  • TCPIP. Connect using TCP/IP protocol.

If the Protocol parameter is specified, then AnyDAC will build full database path, using appropriate to Protocol format and Server and Database parameter values.

TCPIP

Server

Server address to connect to. Server parameter value is used only if Protocol parameter is specified.

127.0.0.1

InstanceName

The Interbase 2007 instance name.

srv2

SQLDialect

The SQL Dialect to use for connection. 3 is the default value.

1

RoleName

The default role name.

Admin

CreateDatabase

Specify Yes to create new database file, specified in Database parameter, right after connecting to the server. No is the default value.

Yes

PageSize

The page size used for new created database. Used if CreateDatabase = Yes. 1024 is the default value.

4096

IBAdvanced

The ';' separated list of additional parameters. You can find the full list of supported parameters in uADPhysIBWrapper unit, searching for DPBInfos constant array. The description of each Code listed there you can find in Interbase / Firebird manuals.


Usage cases

  • connect to a database running on a remote server via the TCP/IP protocol 

DriverID=IB
Database=C:\ib\ADDEMO_FB21.FB
Protocol=TCPIP
Server=IBSrv
User_Name=sysdba
Password=masterkey
  • connect to a database running on a remote server via TCP/IP protocol 

DriverID=IB
Database=IBSrv:C:\ib\ADDEMO_FB21.FB
User_Name=sysdba
Password=masterkey
  • connect to a local database 

DriverID=IB
Database=C:\ib\ADDEMO_FB21.FB
User_Name=sysdba
Password=masterkey
  • connect to a Firebird Embedded database

Drop TADPhysIBDriverLink component to the form and set it VendorLib to <your path>\fbembed.dll or use virtual driver definition. 

DriverID=IB
Database=C:\ib\ADDEMO_FB21.FB
User_Name=sysdba


See Also


Product: RemObjects AnyDAC
Current version: AnyDAC 2.0

Glossary — Features — How To — Components — Tools — Samples — Articles — Architecture — Issues

Retrieved from "http://wiki.remobjects.com/wiki/Connect_to_Interbase_or_Firebird_Server_%28AnyDAC%29"
Personal tools