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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2002

Added on Sep 25 2002

7 comments

18,509 views