Many external DBs are supportet but not Firebird.
Not sure if FileMaker should spend a lot of resources on this.
You may find an ODBC driver already.
or use SQL functions in MBS FileMaker Plugin to connect directly in your scripts to make queries and receive/send records.
What kind of support were you expecting between FileMaker and Firebird?
More details, please?!
Sent from miPhone
ODBC support for Firebird would be great. Its not supported yet.
Supported so far in 16:
MS SQL Server 2014 / 2016
MySQL 5.7.14 Community Edition
Oracle 11g R2 / 12c R1
IBM i 7.1 (AS/400)
IBM DB2 10.5
If you try to access the ODBC driver it sayes Database not supported.
Those are approved for ESS. You may be able to connect and use Import & Execute SQL script steps. I cannot test, so cannot verify that is the case. Long before ESS the methods for ODBC connection was to use those script steps.
Does this work for external sources that may be SQL? Or just to query FM tables/fields with SQL statements, clauses, & functions?
via MBS FileMaker Plugin you need to write scripts and use SQL statements.
The plugin does not magically provide a new ESS source as FileMaker Inc. has no interface for me to provide that.
e.g. like here in an example for MySQL:
MBS Blog - Tip of the day: Connect to MySQL and run a query
Thank you! So back to the topic: "Firebird", there is no direct way to query with the plug-in, is that correct? This would not be an ESS (approved) source, but another SQL db (presumably using ODBC). Is there a method to set up the ODBC source within the plug-in? If so, can you describe for the OP?
MBS FileMaker Plugin does Firebird directly without ODBC.
Connecting to Firebird looks like this with plugin calls:
# start a new connection
Set Variable [$Connection; Value:MBS( "SQL.NewConnection" )]
# if you like set where to find the libraries
Set Variable [$r; Value:MBS( "SQL.SetConnectionOption"; $Connection; "IBASE.LIBS"; "c:\Firebird\fbclient.dll" )]
# connect to database
Set Variable [$r; Value:MBS("SQL.Connect"; $Connection; "MyDatabase"; "MyName"; "MyPass"; "Firebird")]
As you see we need to know where Firebird DLL is, so the plugin can load it. Than you can connect to local or remote database. OP can try the plugin for free and see if it works well for him.
Thank you for helping @firebase to see this as an option! These kinds of details are most helpful for others searching the topic as well.
We support this database types: Centura SQLBase, DB2, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase.
You need native driver installed or include them with your solutions.
No, I was asking for Firebird support as an ESS integration like the other supported ESS sources.
Retrieving data ...