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

    ODBC Issue



      ODBC Issue


      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.