ODBC Connection and Table Not Found error
I am creating an ODBC connection to FileMaker Pro 10. I can successfully do this with several FM7 files however for one file I get this error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Table Not Found: ds09
The initial connection to the database is successful. it is only when I try and query a table that I get the error. (e.g. SELECT * from ds09) The file is setup of for ODBC sharing for All users.
The file name is ds09 and I have confirmed in the Manage Database that the table is also named ds09 also. I have tried copying the FM7 file and renaming both the file and table names just to eliminate Typos. I have also tried a "Recover" of the database.
Any ideas why this does not work for this one file? .I did the same steps on the file and table as I did with several other and they all work.