syvur.blogg.se - Connect to sql server using toad for oracle

ensure that the Installed clients picks up the correct install of your Oracle client.

connect as normal if you are not connecting as sys.

Host = machine name of the database server.

select the "Direct" tab from the right side and enter.

select session/new connection from the menu.

Let's try the easiest way, connecting directly

a user and password, be good and don't connect as sys.

the port the database listener is using (usually port 1521).

is the database parameter db_domain configured with a value? (usually the domain name).name of the database -sometimes called a service name.It's not clear from your question what brand of database you are connecting to.