I am running Windows 7 with UAC enabled. I started TOAD with ‘run as adminstrator’. But I can no longer drag and drop a sql file into the Editor. What could be wrong.
Are you saying that without UAC this all works like a charm?
Could you reproduce steps which gives you correct result?
open User Accounts
select Change User Account Control settings
drag the bar all the way down to Never Notify
disconnect from company LAN, reboot the laptop
after laptop started, reconnect to company LAN
start TOAD
open Editor page in TOAD
open Explorer to a directory where sql script is
drag one of the sql script to TOAD editor – this works, the sql is loaded into TOAD
now when I come in next day, and startup laptop, company policy overwirte UAC and re-enables it
the drag and drop then does not work - nothing happends when I try to drag a file into the TOAD editor
Can you drag files into other applications?
On 11/13/2013 08:17 PM, jimmy wrote:
RE: Drag and Drop not working in TOAD 10.1.1.8 with Windows 7 UAC enabled
Reply by jimmy
open User Accounts
select Change User Account Control settings
drag the bar all the way down to Never Notify
disconnect from company LAN, reboot the laptop
after laptop started, reconnect to company LAN
start TOAD
open Editor page in TOAD
open Explorer to a directory where sql script is
drag one of the sql script to TOAD editor -- this works, the sql is loaded into TOAD
now when I come in next day, and startup laptop, company policy overwirte UAC and re-enables it
the drag and drop then does not work - nothing happends when I try to drag a file into the TOAD editor
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
"A possible reason for the not being able to drag & drop files to the application could be UAC integrity level (IL). With UAC enabled in Vista or Win7, drag and drop is not allowed to happen from low IL process to high IL process by default. Please check whether
your application is elevated (run as admin) when the problem happens."
If you do not run Toad as administrator perhaps it will work; however, I think that Toad requires elevated permissions.
Michael
On 11/13/2013 08:17 PM, jimmy wrote:
RE: Drag and Drop not working in TOAD 10.1.1.8 with Windows 7 UAC enabled
Reply by jimmy
open User Accounts
select Change User Account Control settings
drag the bar all the way down to Never Notify
disconnect from company LAN, reboot the laptop
after laptop started, reconnect to company LAN
start TOAD
open Editor page in TOAD
open Explorer to a directory where sql script is
drag one of the sql script to TOAD editor -- this works, the sql is loaded into TOAD
now when I come in next day, and startup laptop, company policy overwirte UAC and re-enables it
the drag and drop then does not work - nothing happends when I try to drag a file into the TOAD editor
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Sorry forgot to mention that with UAC enabled I had to run TOAD as Administrator. If I do not run TOAD as Administrator, get following error when trying to connect to a database.
“Can’t initialize OCI. Error 1”
With UAC disabled, I am able to run TOAD with or without Administrator and able to drag and drop.
Drag and drop works with other applications such as Notepad, UltraEdit, move files from Explorer to another Explorer ( diff dir ).
Hi Jimmy,
For the OCI.dll error you may want to check the following
Taken from support.quest.com/SolutionDetail.aspx
RESOLUTION 1: Right-click the Toad for Oracle shortcut and select “Run as Administrator” to avoid the error.
RESOLUTION 2: Right-click the Toad for Oracle shortcut | Properties | Compatibility Tab | check mark “Run this program in compatibility mode for” | choose “Windows XP Service Pack 3” from the drop-down list.
RESOLUTION 3: Right-click My Computer | Properties | Advanced tab | Environment Variables | under ‘System Variables’ (lower part) | check if you have an entry for ORACLE_HOME. If yes, rename it to ORACLE_HOME_OLD, and then re-test the issue.
RESOLUTION 4: Upgrade your Oracle client to a version that is 10.2.0.4 or later.
Thanks
Anand
Even if you run those apps as admin?
On Nov 14, 2013, at 12:42 PM, "jimmy" bounce-jimmythio@toadworld.com wrote:
RE: Drag and Drop not working in TOAD 10.1.1.8 with Windows 7 UAC enabled
Reply by jimmy
Sorry forgot to mention that with UAC enabled I had to run TOAD as Administrator. If I do not run TOAD as Administrator, get following error when trying to connect to a database.
"Can't initialize OCI. Error 1"
With UAC disabled, I am able to run TOAD with or without Administrator and able to drag and drop.
Drag and drop works with other applications such as Notepad, UltraEdit, move files from Explorer to another Explorer ( diff dir ).
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Michael,
You are right! Tried with UltraEdit. If I ran that as Admin, not able to drag and drop. If I run as normal, able to drag and drop.
But that presents a problem as I am not able to run TOAD without the run as Admin option, because I get the “Can’t initialize OCI. Error 1” error when I run TOAD without Run as Administrator option.
"Can't initialize OCI. Error 1"
That tends to be an Oracle home and/or environment variable setup issue (i.e. tns_admin and/or sqlnet DLL’s on PATH) ….
Use the open dialog. It may not be ideal, but you have no other option.
On 11/14/2013 01:18 PM, jimmy wrote:
RE: Drag and Drop not working in TOAD 10.1.1.8 with Windows 7 UAC enabled
Reply by jimmy
Michael,
You are right! Tried with UltraEdit. If I ran that as Admin, not able to drag and drop. If I run as normal, able to drag and drop.
But that presents a problem as I am not able to run TOAD without the run as Admin option, because I get the "Can't initialize OCI. Error 1" error when I run TOAD without Run as Administrator option.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.