Temp Table - Missing A Command, Error

Here I am creating a temp table with $ summations that I can later join with an employees table that I'm dumping into a flat file.

select

e.employee_no,
sum(p.fit) as sumfit,
sum(p.fica) - sum(p.medicare) as sumfica,
sum(p.medicare) as sumedic,
sum(p.fit_earnings) as pearnings,
sum(p.fit_earnings) as tearnings

into #earntable

from employees as e
left outer join pay_summary as p on e.employee_no =p.employee_no

where e.employee_no = 817 and
dateadd(d, 0, datediff(d, 0, p.dated)) between '20061231'and '20070401'

group by e.employee_no

select * from #earntable

When I go to look at the contents of the #earntable with the above select, I get this:

ODBC error 214 Procedure expects parameter '@handle' of type 'int'.
(42000)

The datatypes I'm trying to select into the temp table are all
numeric 12 except employee_no char 10.

What am I missing? A drop table statement?