ASP Page using ORA9 "Invalid Identifier" ??

[ajacode]

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Oracle][ODBC][Ora]ORA-00904: "PASSWD": invalid identifier

/SODA_DEV/pages/LoginPage1.asp, line 58

This is the error mesage I get from the asp web page I am connecting to Oracle 9 with an ASP web page and creating a command then a SQL string as such
Here's the SQL
strSQL = "SELECT LOGINID, USERNAME, PASSWD FROM SODA.LOGINS_TB WHERE (LOGINID = 'ajgrasso') AND (PASSWD = 'aj')"

(with no page breaks of course)

Then I execute a command
Set rstUser=connLogin.Execute(strSQL)

But I get the above error message.

The owner of the tables is SODA but I am connecting as SODASUPP could this be a permissions issue ?

Thanks Beforehand

AJ

 

[denoxis]

Are you sure you have PASSWD field in your table?
If you do, try writing it in brackets [PASSWD]