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
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.
MF,
Everything is on 32-bit. Doesn't look like this is the issue.
We're still struggling.
Cheers
Stuart