0 Replies Latest reply on Oct 29, 2010 1:09 PM by shepherdr

    FM Server 11 v2 and ODBC

    shepherdr

      Title

      FM Server 11 v2 and ODBC

      Your post

      We are running Mac osx Server 10.6 and Filemaker Server Advanced 11 v2.

      One of our 'served' databases has ODBC enabled on it, and we connect to it with FedEx and UPS shipping workstations, running windows XP using the Filemaker 11 ODBC driver, which read and write to the database, without issue.

      We also run Cognos Decision Stream, on windows Server 2003, using the 'new' Filemaker 11 v2 ODBC drviver.

      We can connect to the databases using the 'test connection' button on the Filemaker DSN ODBC setup screen.

      When we try to run our Decision Stream process (which we have been runnning successfully since Filemaker Server 7) it fails with the following errors

      1.  ERROR

      DS-DBMS-E400: UDA driver reported  the following on connection 'OTS_DLI':

      DMS-E-GENERAL, A general exception  has occurred during operation 'prepare request'.

      DMS-E-GENERAL, A general exception  has occurred during operation 'prepare request'.

       When speaking to Filemaker Support, their only suggestions as to how to resolve this issue, was to post to here ?

      Does anyone out there have any ideas ?

      thx

      Rick