Home » SQL & PL/SQL » Client Tools » Connecting to Oracle Server with TOAD (windows xp)
Connecting to Oracle Server with TOAD [message #282307] Wed, 21 November 2007 07:43 Go to next message
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


Re: Connecting to Oracle Server with TOAD [message #282309 is a reply to message #282307] Wed, 21 November 2007 07:55 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Connecting to Oracle Server with TOAD [message #282464 is a reply to message #282307] Thu, 22 November 2007 01:16 Go to previous messageGo to next message
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
Re: Connecting to Oracle Server with TOAD [message #282478 is a reply to message #282464] Thu, 22 November 2007 02:09 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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)).
Re: Connecting to Oracle Server with TOAD [message #282492 is a reply to message #282307] Thu, 22 November 2007 02:42 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Ya, I agree with you.
Re: Connecting to Oracle Server with TOAD [message #282552 is a reply to message #282307] Thu, 22 November 2007 05:50 Go to previous messageGo to next message
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
Re: Connecting to Oracle Server with TOAD [message #282631 is a reply to message #282552] Thu, 22 November 2007 15:11 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Install Oracle 10g Express Edition. It is free.
Re: Connecting to Oracle Server with TOAD [message #283919 is a reply to message #282631] Wed, 28 November 2007 07:15 Go to previous messageGo to next message
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 427 times)
Re: Connecting to Oracle Server with TOAD [message #283924 is a reply to message #283919] Wed, 28 November 2007 07:18 Go to previous message
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...
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:
  


Current Time: Sat Dec 10 22:44:12 CST 2016

Total time taken to generate the page: 0.21638 seconds