Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Message "Invalid Identifier"

320880Sep 25 2002
I am using an ASP page to present a SQL query to Oracle 9

I am getting the error message as seen below is my Oracle SQL Syntax incorrect?
********************************************************************************

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2002
Added on Sep 25 2002
7 comments
18,944 views