[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

ORA-00904 Invalid Identifier



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

ORA-00904 Invalid Identifier.

Applies to: SQL Server 2005 Enterprise Edition, Oracle 9i


Problem Description.

In SQL Server 2005 Enterprise Edition, we have set up an Oracle linked server, but when we run a query with OPENQUERY, the following error shows up:

OLE DB provider "MSDAORA" for linked server "ODBCDataSource" returned message "ORA-00904: : invalid identifier".


There could be many causes for this error message, but here you will find three of them:

1) The login used for creating the linked server to the Oracle database needs permissions on one of the objects involved in the query.

2) The query may include a Oracle function that ODBC is not able to handle.

3) There is a column name either missing or invalid.



.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.