Data Manager Connection to Filemaker

[SynexusStuart]

All,

We have a small database which is in Filemaker11. This has recently been changed from Filemaker10.

When we were using Filemaker10, the ODBC driver used was  "DataDirect 32-BIT SequeLink 5.5".
Having moved to FM11 we are using the native Driver "Filemaker ODBC" - this is due to problems between FM11 and the old driver.

The ODBC connection tests sucessfully and the Connection in Data Manager connects sucessfully however, when we try a simple select statement (using the "add table select statement" option) from the database we encounter the following error:

1. ERROR
DM-DBM-0400 UDA driver reported the following on connection Synexus Telescreen FM11:

UDA-SQL-0107 A general exception has occurred during the operation "prepare".

We are really struggling with this one. Does anyone have any suggestions?

Stuart

[MFGF]

Probably a complete red herring, but worth a mention just in case...  Is the new ODBC 32-bit or 64-bit? I have recently come across an issue where a colleague was trying to use a 64-bit ODBC driver installed on a 64-bit OS from a 32-bit Cognos install, and seeing vaguely similar issues.  Installing and configuring the 32-bit driver fixed the problem.

Regards,

MF.

[SynexusStuart]

MF,

Everything is on 32-bit. Doesn't look like this is the issue.

We're still struggling.

Cheers
Stuart