Turns out TSR and QSR both support direct connect. As an experiment, I created a simple file that contained select * from scott.emp;
I then ran TSR using the following command line syntax:
-f “c:\hr.sql” -c gliss/XXXX@192.168.218.133:1521/XE -o “c:\output.txt”
The more generic version is:
-f “c:\scott.sql” -c /@:/<service_name> -o “c:\output.txt”
Can you connect so SQL*Plus using that syntax? connect /@:/<service_name
Can you try that test on QSR/TSR?
From: grego [mailto:email@example.com]
Sent: Wednesday, August 07, 2013 6:35 PM
Subject: RE: [Toad for Oracle - Discussion Forum] “Unable to create Oracle session” in MyToad
RE: “Unable to create Oracle session” in MyToad
Reply by grego
Thanks Greg, appreciate it. This is the method my team uses, so if it can be added as an enhancement, that would be great.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.