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