1 Reply Latest reply on Jan 12, 2010 11:39 AM by kapitaen_1

    ODBC Issue

    MikeyG79

      Title

      ODBC Issue

      Post

      Trying to make an ODBC call to a FM10 server (win2003) from my XP workstation with the Datadirect ODBC driver.

      Using Perl, I can run this query fine:

       

      SELECT Activity.Status, Activity.ResourceName_Date FROM Activity

       

      When I try to run this:

      SELECT Activity.Status FROM Activity WHERE Activity.ResourceName_Date = "Michael01122009"

       

      it fails saying Column Not Found  Michael01122009. Can't understand why.