[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
ORA-00904 Invalid Identifier

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

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".


Cause.

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.