Re: How to access Oracle database with Windows Excel's Q+E ?

From: Magne Maehre <magne_at_ddm1.ddm.st.statoil.no>
Date: Fri, 23 Oct 1992 08:29:27 GMT
Message-ID: <1992Oct23.082927.10877_at_statoil.no>

In article <Stouder.3.719765346_at_cmu.unige.ch>, Stouder_at_cmu.unige.ch (Stouder Alain) writes:
> Hi,
>
> I would like to access a Oracle v6 database located on a Sun server with
> Pioneer Q+E that is sold with Microsoft Excel 4.0 for Windows.
> I launch smartdrv.exe then ethdrv.exe (TCP/IP) then SQL*NET and then
> in Windows Q+E asks for server name, user name & password.
> That's where I got an SQL error... It doesn't recognize the server name
> along with the user info.
> We have the same problem with Oracle DDE/Toolbook.
> Any idea ?
>
> Thanks.
> --Alain Stouder, University of Geneva

The format for server name in Oracle is <Transport>:<Servername>:<Database> If you use TCP/IP towards a server called 'ddm1' with a database named 'DB', the server field shoul read 'T:ddm1:DB'. (T = TCP/IP)

-Magne Received on Fri Oct 23 1992 - 09:29:27 CET

This message: [ Message body ]
Next message: David Ruthven: "Re: How can I store, search and retrieve large text fields?"
Previous message: sstephen_at_us.oracle.com: "Re: Indexes - Are yours larger then the table?"
In reply to: Stouder Alain: "How to access Oracle database with Windows Excel's Q+E ?"
In reply to Stouder Alain: "How to access Oracle database with Windows Excel's Q+E ?"
Next in thread: David Ruthven: "Re: How can I store, search and retrieve large text fields?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message