Integrating with SQL databases v1

Flowgear includes the following Connectors for SQL.

It also includes generalized Connectors for ODBC and OLE DB:

Parameterize data values. Do not concatenate caller input into SQL text. See Avoiding SQL Injection Attacks.

Working with ODBC

  1. Obtain and install the appropriate ODBC driver.
  2. Install a DropPoint on the machine where you installed the ODBC driver.
  3. Provide a connection string that specifies the driver. ConnectionStrings.com provides examples for many ODBC drivers.

Common ODBC Drivers and Connection Strings

Firebird

Drivers are available from the Firebird ODBC driver page.

DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=C:\database\myData.fdb;

MySQL

Drivers are available from the MySQL Connector/ODBC page.

Driver={MySQL ODBC 5.1 Driver};Server=your_server_name.net;User=username;Password=password;Database=database

For ODBC Table Update, use these parameters in the Connection:

  • ParameterPrefix - ?
  • AllowNamedParameters - False
  • ObjectEncapsulator - leave empty
  • SelectSql - select * from {table} limit 0

Pervasive SQL

See the Progress DataDirect Pervasive SQL driver release history for current driver information.

Driver={Pervasive ODBC Client Interface};servername=server_name_or_ip;dbq=data_source_name

For ODBC Table Update, use these parameters in the Connection:

  • ParameterPrefix - ?
  • AllowNamedParameters - False
  • ObjectEncapsulator - ""
  • SelectSql - select * from {table} limit 0

HANA SQL

Drivers are available through SAP Help Portal.

DRIVER={HDBODBC};SERVERNODE=server_name_or_ip:30015;UID=username;PWD=password