Connect to Blackfish SQL Server (AnyDAC)

From RemObjects Software

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

Blackfish SQL Server Overview

AnyDAC v 2.0 currently does not provide a native Blackfish SQL Server driver, but you can use the AnyDAC/TDBX Bridge driver to connect to the Blackfish SQL Server. You should use TDBX (DBX 4) Framework and Blackfish SQL driver, which comes with CodeGear RadStudio 2007 or higher.

Connect using the AnyDAC/TDBX Bridge

To connect to the Blackfish SQL Server do the following:

• Open the file "C:\Documents and Settings\All Users\Documents\RAD Studio\dbExpress\dbxdrivers.ini". Find the [BlackfishSQL] section and modify it:
  • add "HostName=ServerName" ;
  • replace "Create=False" with "create=False".
• Create a connection definition, similar to this example. Note, the "create" parameter must be specified using lower case characters.

[My_BSQL]
DriverName=BlackfishSQL
DriverID=TDBX
hostname=127.0.0.1
port=2508
database=c:\addemo
create=True
user_name=sysdba
password=masterkey

• Drop a TADDatabase component on the form
• Set ADDatabase1.ConnectionDefName to My_BSQL

See Also

• AnyDAC Database Connectivity
• AnyDAC FAQs
• How to configure AnyDAC Drivers
• How to manage AnyDAC Connection Definitions
• Programming with dbExpress 4

Product: RemObjects AnyDAC
Current version: AnyDAC 2.0

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