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.