Re: ODBC, Oracle 7.3.4 and MS Excel

From: David Ramsey <dramsey_at_voicecommander.com>
Date: Thu, 11 Feb 1999 09:43:10 -0600
Message-ID: <36C2FA8E.DD56FB4C_at_voicecommander.com>


Thanks Ian and I think that might actually be the case but Microsoft Excell does not give me any Next Rowset button. I was hoping there was a way to configure this to get the entire set or perhaps another solution.

Ian Holmes wrote:
>
> David,
>
> This might be a silly question, but are you sure that the ODBC Data Source
> Window isn't only DISPLAYING the first four tables? This has happened to me
> before, until I remember to click on the Next RowSet button and then I see
> all the other tables, 4 or 5 at a time.
>
> Cheers,
> Ian.
>
> David Ramsey <dramsey_at_voicecommander.com> wrote in article
> <36C2230D.DAF78E09_at_voicecommander.com>...
> > ....
> >
> > 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 |
> > ==============================================================
> >

-- 
==============================================================
| "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 - 16:43:10 CET

Original text of this message