ODBC, Oracle 7.3.4 and MS Excel

From: David Ramsey <dramsey_at_voicecommander.com>
Date: Wed, 10 Feb 1999 18:23:41 -0600
Message-ID: <36C2230D.DAF78E09_at_voicecommander.com>

I have a view created in an Oracle 7.3.4 database that we intended to allow accounting access to via ODBC into an Excel spreadsheet.

If I use the Oracle user ID created for accounting to get access to this view through Excell, I get a response that "THIS DATA SOURCE CONTAINS NO VISIBLE TABLES". The tables and views in question belong to another user account in the database.

If I connect to the database via SQLPLUS as the accounting user I can access the tables and views fine. (Appropriate synonyms and grants have been setup for that user to access these tables.) Thus, I don't think this is a SQL*NET problem. If I connect to the database via SQLPLUS as the table owner, I can also access the tables and views fine.

[Quoted] However, If I connect through Excel to the data source as the table owner, the list of available tables only shows the first 4 tables owned by the table owner.

SQL*NET version is: 2.3.4.0.0
ODBC Driver version from Oracle is: 2.5.3.1.0B

Oracle 7.3.4 is running on a DEC AlphaServer 1200 running DEC UNIX 4.0d.

Any suggestions here would be helpful.

Thanks.

-- 


==============================================================

| "Always listen to experts. They'll tell you what can't be  |
| done, and why. Then do it."                                |
| -- Lazarus Long, in Robert Heinlein's Time Enough for Love |


==============================================================

Received on Thu Feb 11 1999 - 01:23:41 CET