niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle » Tools
Oracle <--> Excel, using Toad
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
Author Message
Praveen
*nix forums beginner


Joined: 10 Feb 2005
Posts: 30

PostPosted: Tue Jul 11, 2006 7:02 am    Post subject: Oracle <--> Excel, using Toad Reply with quote
Hi
i need your help for connecting Oracle database to Excel .
We have Oracle 7 (7.3.3.6) Parllel Server running on VMS platform
(VMS-7.1.2).
I would like to connect to the Oracle, through Excel running on Windows
NT,servicepack (6a). I would like to use Toad software (Freeware), for
this requirement.
Now my points are:
Is i need to install any Oracle client application on PC, then is it
required to install Oracle 7 only,(or i can install higher version
Oracle 9i).
How to configure Oracle parller server to allow it to accessed by
client application running on PC.
Please note that iam very new to Oracle, so please elaborate your
reply.
Thanks in advance for your replies.
Back to top
Robbert van der Hoorn
*nix forums beginner


Joined: 29 Jun 2006
Posts: 16

PostPosted: Tue Jul 11, 2006 7:41 am    Post subject: Re: Oracle <--> Excel, using Toad Reply with quote
"Praveen" <bpraveen2@gmail.com> wrote in message
news:1152601374.944200.169580@b28g2000cwb.googlegroups.com...
Quote:
Hi
i need your help for connecting Oracle database to Excel .
We have Oracle 7 (7.3.3.6) Parllel Server running on VMS platform
(VMS-7.1.2).
I would like to connect to the Oracle, through Excel running on Windows
NT,servicepack (6a). I would like to use Toad software (Freeware), for
this requirement.
Now my points are:
Is i need to install any Oracle client application on PC, then is it
required to install Oracle 7 only,(or i can install higher version
Oracle 9i).
How to configure Oracle parller server to allow it to accessed by
client application running on PC.
Please note that iam very new to Oracle, so please elaborate your
reply.
Thanks in advance for your replies.


Hi Praveen,

I had to check the date of your message to see if it was posted this year or
far in the past...
You are using a desupported Oracle version, and an old version of NT (it's
4.0, isn't it?)
However, to connect to Oracle from Excel, you might need Oracle Objects For
OLE (OO4O), or you could use an ODBC connection and configure it in Excel.
OR you could export your data through Toad from the data grid to Excel (I
don't know if free Toad supports this). It all depends on whether you wish
to have a live connection to Oracle or just export/import your data in
Excel.
I don't think OO4O is still vailable for this version, unless you still have
some installation CD's yourself.. You do need SQL client for Oracle 7 on
your PC to connect from TOAD to Oracle. You don' need to do anything on the
server (except creating an account etc).

Robbert

Robbert
Back to top
Sybrand Bakker
*nix forums Guru


Joined: 03 Apr 2005
Posts: 1766

PostPosted: Tue Jul 11, 2006 5:22 pm    Post subject: Re: Oracle <--> Excel, using Toad Reply with quote
On 11 Jul 2006 00:02:55 -0700, "Praveen" <bpraveen2@gmail.com> wrote:

Quote:
Hi
i need your help for connecting Oracle database to Excel .
We have Oracle 7 (7.3.3.6) Parllel Server running on VMS platform
(VMS-7.1.2).
I would like to connect to the Oracle, through Excel running on Windows
NT,servicepack (6a). I would like to use Toad software (Freeware), for
this requirement.
Now my points are:
Is i need to install any Oracle client application on PC, then is it
required to install Oracle 7 only,(or i can install higher version
Oracle 9i).
How to configure Oracle parller server to allow it to accessed by
client application running on PC.
Please note that iam very new to Oracle, so please elaborate your
reply.
Thanks in advance for your replies.

Oracle 7.3.3 --> desupported
VMS 7-1.2 _--> likely desupported
NT 4.0 ---> desupported

You are on your own.

People being new to Oracle should read the concepts manual and not ask
such questions as '>How to configure Oracle parller server to allow it
to accessed by
Quote:
client application running on PC
Apart from the fact this is ghastly English, it betrays you expect

this forum to teach you Oracle, and you are not prepared to spend any
effort on learning it.

--
Sybrand Bakker, Senior Oracle DBA
Back to top
George Lewycky
*nix forums beginner


Joined: 02 Jun 2005
Posts: 11

PostPosted: Thu Jul 13, 2006 8:36 pm    Post subject: Re: Oracle <--> Excel, using Toad Reply with quote
I have an illustration on my website on how to do this
its very simple and it can output data in many formats - i use it all
the time

George

http://georgenet.net/oracle




Praveen wrote:
Quote:
Hi
i need your help for connecting Oracle database to Excel .
We have Oracle 7 (7.3.3.6) Parllel Server running on VMS platform
(VMS-7.1.2).
I would like to connect to the Oracle, through Excel running on Windows
NT,servicepack (6a). I would like to use Toad software (Freeware), for
this requirement.
Now my points are:
Is i need to install any Oracle client application on PC, then is it
required to install Oracle 7 only,(or i can install higher version
Oracle 9i).
How to configure Oracle parller server to allow it to accessed by
client application running on PC.
Please note that iam very new to Oracle, so please elaborate your
reply.
Thanks in advance for your replies.
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
The time now is Sun Nov 23, 2008 11:42 am | All times are GMT
navigation Forum index » Databases » Oracle » Tools
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Move Oracle 10g database to another location Selt Server 0 Fri Jul 21, 2006 2:14 pm
No new posts Oracle runtime Spitfire Server 0 Fri Jul 21, 2006 1:18 pm
No new posts Oracle Text Score Computation jatinder.1975@gmail.com Server 0 Fri Jul 21, 2006 1:00 pm
No new posts Can a trigger insert records into another oracle server Tauqir Server 2 Fri Jul 21, 2006 12:27 am
No new posts Moving Oracle filesystem to SAN howard Server 1 Thu Jul 20, 2006 11:49 pm

ADHD Coach | Personal Loans | Remortgages | Online Advertising | Web directory
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1691s ][ Queries: 16 (0.0823s) ][ GZIP on - Debug on ]