Problems using ODBC connection in Visual Studio 2005

[Pep]

Hi, I have to access a Faircom database using ODBC and am having
problems with a query run from visual studio 2005.

I can run the floowing query in MSAccess with no problem

SELECT admin_transact.when AS myWhen,
dateadd("s",admin_transact.when, "1970-01-01 00:00:00") AS Expr1
FROM admin_transact
WHERE (admin_transact.when 1165190400)

But in Visual Studio I cannot run the equivalent query?

SELECT "when" AS myWhen, dateadd(s, "when", "1970-01-01 00:00:00")
AS Expr1
FROM admin.transact
WHERE ("when" 1165190400)

Does visual studion or dotnet require anything special to be done in
order to run odbc queries effectively?

TIA,
Pep.