COUNT command rejected in SQL Query   

My C# Windows program does not recognize the COUNT command in a SQL query 
string using SQL Server 2005.  I can use the command when I code the query 
manually against the data base.  It rejects the command SELECT COUNT(*) FROM 
EARNDED.  Does anyone know how to get around this problem?
Dave

date: Tue, 3 Jun 2008 17:41:02 -0700   author:   Parrot

RE: COUNT command rejected in SQL Query   

I forgot to mention that I have this problem only on my computer with the 
VISTA system whereas it works ok on the computer with XP.  Why would an 
operating system make a difference.  Also, I used SQLEXPRESS on the XP while 
I use the SQL SERVER 2005 on VISTA.
Dave

"Parrot" wrote:

> My C# Windows program does not recognize the COUNT command in a SQL query 
> string using SQL Server 2005.  I can use the command when I code the query 
> manually against the data base.  It rejects the command SELECT COUNT(*) FROM 
> EARNDED.  Does anyone know how to get around this problem?
> Dave

date: Tue, 3 Jun 2008 19:03:00 -0700   author:   Parrot