Re: Excel 97 to Oracle 7.3.4 via ODBC problems

You can also get around the invalid username/password error by entering the username and password all in the username file as 'username/password'.

The MS-OFFICE SP2 is your better bet, but the above will work.

Cheryl Miller
DBA
cmiller_at_stlnet.com

Geoff Ingram wrote in message <369672C4.9B3FD968_at_gvingram.demon.co.uk>...
>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
>
Received on Sun Jan 24 1999 - 16:26:32 CST