Toad World® Forums

Toad using ODBC connection

How to connect toad for oracle using ODBC connections. I have created ODBC dsn for oracle db.

Morning Kar4290,

Welcome to the forum.

Toad uses a locally installed Oracle Client to connect to a database. Your ODBC session(s) should also be using a locally installed Oracle Client, so you should be good to go. As far as I am aware, Toad doesn't use ODBC connections.

On the Session->New Session dialogue, you can pick to connect to Oracle databases using:

  • TNS Names aliases, where you supply (or pick) an alias from the list defined in your Oracle Client's %ORACLE_HOME%\network\admin\tnsnames.ora file;
  • LDAP where you supply/pick an LDAP descriptor to connect with;
  • Direct connections, where you would supply the host, port and either the service name or SID for the database. This option is most likely the one you could use instead of ODBC as, if I remeber correctly, ODBC needs similar data?

HTH

Cheers,
Norm. [TeamT]

2 Likes