Re: Oracle7 and Excel 4.0
Date: Wed, 19 Jan 1994 08:18:51
Message-ID: <lbird.1.000850AF_at_ucs.ubc.ca>
In article <1994Jan18.130055.2773_at_zh014.ubs.ubs.ch> zhrmc_at_zh014.ubs.ubs.ch (Michael Rieder) writes:
>From: zhrmc_at_zh014.ubs.ubs.ch (Michael Rieder)
>Subject: Oracle7 and Excel 4.0
>Date: Tue, 18 Jan 1994 13:00:55 GMT
>Hi there,
>I'm trying to connect to Oracle7 using Q+E for Excel 4.0 on a PC.
>I can open the connection (through Q+E) using ODBC. Q+E will show me
>a list of possible tables, views and synonyms. When I select one of those
>objects and click OK. Q+E shows a message box telling about an Oracle error
>ORA-00942: table or view does not exists.
Q+E may be looking for dictionary tables that don't exist (by default) in the Oracle7 dictionary. Certain tables that belonged to an older SQL standard were not included in the Oracle7 dictionary.
If this is the problem, your DBA can run the script CATALOG6.SQL to create Oracle V6 compatible views. Received on Wed Jan 19 1994 - 08:18:51 CET