AnsweredAssumed Answered

FileMaker Server 16 ODBC correction error

Question asked by drjlp on Oct 9, 2018
Latest reply on Oct 11, 2018 by drjlp

I am trying to connect software that downloads email attachment to Filemaker 16 server. (The email software  can be set up to import the attachment records into a database).  I have the latest ODBC drivers which test fine and work with Access 2007 and the Server.  The email attachment software is being tested on a Windows 7 desktop.

The connection string I am using is

Server=servername (actually an address);Database= dbname;UID= userid;Pwd=password

The error returned is:

Connection Failed:Error [HY000] [Filemaker][Filemaker] FQL0002/(1:14) The table named "DUAL" does not exist.


I have looked high and low for an explanation of the error;  Any suggestions or advice would be appreciated. Thanks for your time.