Re: Excel 97 to Oracle 7.3.4 via ODBC problems

Gerritt-Jan,

the original question was about a problem with MS Query. What's the best interface for accessing Oracle from Excel is a completely different question. I use VBA mostly to access Oracle from Excel simply because it does 95% of what I want. I already have ODBC and VBA installed. No hassle involved.

PS please don't use my email id in the Reply-To field for your posts

gjlinker_at_geocities.com wrote:

> Dear Babette and Geoff,
>
> You can avoid the ODBC hassle. I wrote an addin for Excel to talk to Oracle.
> It is very user friendly and comes about as a new menu item in Excel.
>
> Oraxcel takes your query and fetches the results in the spreadsheet. You can
> even change the fetched data on the spreadsheet and post all the changes back
> in one go. Also Oraxcel now can do SQL*Loader type of work: mass insert a
> whole spreadsheet into Oracle in one go.
>
> Have a look at:
> http://members.aol.com/gjlinker
>
> There is loads of demo's and screen prints on the site.
>
> Regards, Gerrit-Jan Linker
>
> In article <369672C4.9B3FD968_at_gvingram.demon.co.uk>,
> geoff_ingram_at_ml.com wrote:
> > you can only use file based DSN using MSQuery with Excel97 unless you install
> > MSOffice SP2. This is hidden away somewhere in the docs.
> >
> > Babette Turner-Underwood wrote:
> >
> > > Hello Fellow Oracle users
> > >
> > > I am trying to get Excel to talk to Oracle with NO LUCK.
> > > Versions:
> > > excel 97
> > > oracle 7.3.4 (on UNIX Server)
> > > odbc drive for oracle 7.3 version 2.5 (downloaded from technet today)
> > >
> > > I am able to install the ODBC driver. At least it shows up in the
> > > ODBC 32-bit admin driver list and allows me to create a data source
>
> > > for it.
> > >
> > > However, in Excel, I select Data--> External Source --> New Query
> > > the previously created data source does not appear. Instead there
> > > are five Excel default data sources and one that says <new source>.
> > >
> > > If I try and add a <new data source> from within Excel, it allows me
> > > to create a name, select the Oracle driver and then press <connect>
> > > button. A login pop-up appears. I enter userid, password and connect
> > > string (identified in tnsnames.ora on same machine).
> > >
> > > I then get an ORA-1017 Invalid username / password logon denied error
> > > and then the Excel data source is not created.
> > >
> > > What am I doing wrong? Am I using the wrong drivers?
> > > Please help
> > >
> > > Babette Turner-Underwood, TMI Communications
> > > babettet_at_tmi.ca
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Jan 16 1999 - 09:23:52 CST