Menu

error message in Microsoft Query - ORA-00903 invalid table name

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Jamie Collins Jamie Collins is offline

Jamie Collins is offline

external usenet poster

Posts: 593

Default

error message in Microsoft Query - ORA-00903 invalid table name

(bert) wrote ...

I receive the error-message for an easy select (Microsoft Excel2000
SP3 - Query)like:
select SYSDATE from dual

Occurs this error due to a wrong odbc-driver???

In a sql-navigator the select works fine.

I assume we are talking about MS Query (Data, Import External Data,
New Database Query...)

In MS Query, try using the GUI tools to build a simple SELECT * FROM
query e.g. choose Table, Add Table, when added double click on the *,
then View, SQL. The resulting syntax is a strange dialect (especially
when aliasing tables) but may give you some clues.

You'll want to ensure MS Query has no hope of mistakenly recognizing
your Oracle SQL as being its own dialect: if it does it will try and
validate it on the client side and will have problems with proprietary
syntax such as SYSDATE. You want MS Query to *fail* to recognize the
syntax, in which circumstance it will use odbc 'pass through'
functionality to pass the sql without validation to be execute on the
server side.

Or it could just be an issue with the machine's set up e.g. have you
installed the Oracle client?

Jamie.

--

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula with Invalid References Error Message	DOUG	Excel Discussion (Misc queries)	5	August 17th 09 07:13 PM
Microsoft Query Error w/ Navision	Laura	Excel Discussion (Misc queries)	0	October 2nd 06 06:35 PM
Error message Microsoft Graph is part of another programme	Alimyb	Setting up and Configuration of Excel	0	August 14th 06 11:28 AM
Syntax Error - Using Microsoft Query and ODBC link to a table	James T	Excel Discussion (Misc queries)	0	August 31st 05 02:18 AM
'Undefined Function' Error in Microsoft Query	Jim Molter[_2_]	Excel Programming	1	September 9th 03 11:20 AM

All times are GMT +1. The time now is 09:05 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement