SQL statement works in Sql Server Management Studio but not in Application Engine

Hi Experts,

I'm getting a SQL error when running a SQL statement in an Application Engine program.  However, when I test the statement in SQL Server Management Studio I get no error. 

 

Here is the error message:  [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'HR9PRO.DBO.PS_PROJECT'.

Of course the PS_PROJECT table does exist, but the database owner name is actually (lower-case) dbo.  In the error message above it's uppercase and I don't know where the case is changed and if perhaps that's why the SQL engine isn't recognizing the object name as valid.