Re: Excel 97 to Oracle 7.3.4 via ODBC problems

Dear Babette,

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 <vQrl2.353$PD.2515274_at_news.magma.ca>,   "Babette Turner-Underwood" <babettet_at_you.cant.spam.me> 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 Wed Jan 13 1999 - 15:33:25 CST