Toad World® Forums

How to connect to oracle database using Direct in Toad Data Point

I cannot connect to oracle database from Toad Data Point using Direct. Is SID required? I also use Toad for Oracle and we use service name and it works fine. But it wouldn’t let me connect if I use service name in Toad Data Point. Can somebody help?

Thanks,

Z

What version of TDP are you using. The latest version connects to both SID and Service names. However, I don’t suggest using Direct Connect. You get a much faster and more stable connection if you use an OCI Client. It can be an instance client or full. 32-bir or 64.