AnsweredAssumed Answered

ODBC Issue

Question asked by MikeyG79 on Jan 12, 2010
Latest reply on Jan 12, 2010 by kapitaen_1


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.