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

In article <1992Oct23.082927.10877_at_statoil.no>, magne_at_ddm1.ddm.st.statoil.no (Magne Maehre) writes:
>
> 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

The version of Q+E that comes packaged with Excel will not allow you access and external databases eg Oracle. To get access to Oracle, you need to obtained the database server version of Q+E. This can be done by upgrading the version of Q+E that comes with Excel.

P.S. This may sound silly but you need SQL*Net as well on your PC.

-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu_at_cmutual.com.au