AnsweredAssumed Answered

ODBC Connection and Table Not Found error

Question asked by KarlZ on Jun 18, 2009
Latest reply on Jun 22, 2009 by philmodjunk


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.