1 Reply Latest reply on Apr 11, 2013 10:15 PM by Fred(CH)

    FileMaker Pro

    XiaoyanWeng

      Product

      FileMaker Pro

      Description of the issue

      I am using ODBC to connect to a view in our Oracle database. The ODBC connection works fine. But the data cannot displayed (all became [Oracle][ODBC][Ora]) in Filemaker Pro when I tried to preview it. I did select the right Layout. The error message says ODBC Error: [Oracle][ODBC][Ora]ORA-00936: missing expression.

      Any one can help? Thanks in advance.

        • 1. Re: FileMaker Pro
          Fred(CH)

               Hi Xiaoyan,

               Can you please edit your post to complete the Configuration Details that are very very important on thoses cases (almost in all in fact) ?

          Assuming that you talk about a local config without FileMaker Server hosting :

               • FileMaker Pro Version number

               • Mac or Win and OS Version

               • The ODBC Pilot Name, Developer and Version.

               Thanks a lot in advance and sorry for the additionnal work smiley.

               Bye, Fred