Flowgear supports integration with Microsoft SQL databases directly through the SQL Query and SQL Table Update Connectors.
You can connect to other databases via either our ODBC or OLEDB connectors namely:
Working with ODBC
Obtain and install the appropriate ODBC driver
Install a DropPoint on the machine you've installed the ODBC driver on
Provide a connection string that specifies the ODBC driver that you want to use (http://connectionstrings.com is a good resource for obtaining ODBC driver connection strings).
Common ODBC Drivers & Connection Strings
Firebird
Drivers are available at https://firebirdsql.org/en/odbc-driver/
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.fdb;
mySQL
Drivers are available at http://dev.mysql.com/downloads/connector/odbc/
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 -
FalseObjectEncapsulator - leave empty
SelectSql -
select * from {table} limit 0
Pervasive SQL
Drivers are available at https://www.progress.com/odbc/pervasive-sql
Driver={Pervasive ODBC Client Interface};servername=server_name_or_ip;dbq=data_source_nameFor ODBC Table Update, use these parameters in the Connection:
ParameterPrefix -
?AllowNamedParameters -
FalseObjectEncapsulator -
""SelectSql -
select * from {table} limit 0