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.