AnsweredAssumed Answered

FM Server 11 v2 and ODBC

Question asked by shepherdr on Oct 29, 2010

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

Outcomes