OraFAQ Forum: Client Tools » Connecting to Oracle Server with TOAD

Home » Other » Client Tools » Connecting to Oracle Server with TOAD (windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting to Oracle Server with TOAD [message #282307]

Wed, 21 November 2007 07:43

ravikumark
Messages: 3
Registered: November 2007

Junior Member

Hi all,

I am a new TOAD user, I installed TOAD in the machine and trying to connect to oracle server,when i am trying to create a new connection it is showing "no clients installed" error.

my doubts are:

1.Is oracle client compulsory in the machine where TOAD is installed?

2.Is there any alternate to connect to server without Oracle client installtion for ex: odbc drivers etc...

Please let me know your comments and suggestions which are very helpful.

Thanks,
Ravikumar

Report message to a moderator

Re: Connecting to Oracle Server with TOAD [message #282309 is a reply to message #282307]

Wed, 21 November 2007 07:55

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If I remember well, such a question has been asked here recently. Try to find the answer using OraFAQ Forum's Search facility.

Report message to a moderator

Re: Connecting to Oracle Server with TOAD [message #282464 is a reply to message #282307]

Thu, 22 November 2007 01:16

kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India

Senior Member

Here it is,

http://www.orafaq.com/forum/t/90386/115564/

Cheers,
Kiran

Report message to a moderator

Re: Connecting to Oracle Server with TOAD [message #282478 is a reply to message #282464]

Thu, 22 November 2007 02:09

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Thank you, but that's not the point; I could have searched for it myself, but Ravikumar wouldn't learn how to use Search (or even read OraFAQ Forum Guide to learn how to help himself to get a quick answer to his question(s)).

Report message to a moderator

Re: Connecting to Oracle Server with TOAD [message #282492 is a reply to message #282307]

Thu, 22 November 2007 02:42

kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India

Senior Member

Ya, I agree with you.

Report message to a moderator

Re: Connecting to Oracle Server with TOAD [message #282552 is a reply to message #282307]

Thu, 22 November 2007 05:50

ravikumark
Messages: 3
Registered: November 2007

Junior Member

hi all,
thanks for the help, i searched in the forum and got the answer.
as per the forum the answer is
either
use OraCMD -command prompt for oracle
OR
Install Oracle Client.

is there any other way to connect to database through TOAD without installing oracle client?

this would help me not to purchage a new oracle client licence.

Thanks,
Ravikumar

Report message to a moderator

Re: Connecting to Oracle Server with TOAD [message #282631 is a reply to message #282552]

Thu, 22 November 2007 15:11

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Install Oracle 10g Express Edition. It is free.

Report message to a moderator

Re: Connecting to Oracle Server with TOAD [message #283919 is a reply to message #282631]

Wed, 28 November 2007 07:15

ravikumark
Messages: 3
Registered: November 2007

Junior Member

i installed oracle client XE(Express Edition), even then the problem remained resolved.

apart from that i installed ODBC drivers too..

please suggest.

i am attaching the error file
--ravikumar

Attachment: error.JPG
(Size: 91.35KB, Downloaded 1165 times)

Report message to a moderator

Re: Connecting to Oracle Server with TOAD [message #283924 is a reply to message #283919]

Wed, 28 November 2007 07:18

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Your getting ORA-12514 error ...just search on forms you will get solution...

Report message to a moderator

Previous Topic:	SQL sentense longer than 1152 signs, make an ORA-03135 and ORA-3114
Next Topic:	oracle log in problem while log ing in second time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:46:31 CDT 2024