Toad World® Forums

Drag and Drop not working in TOAD 10.1.1.8 with Windows 7 UAC enabled


#1

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.


#2

Are you saying that without UAC this all works like a charm?

Could you reproduce steps which gives you correct result?


#3

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


#4

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.


#5

From…
http://social.msdn.microsoft.com/Forums/vstudio/en-US/0b68346d-8102-496b-98dd-5a204bef536d/windows-7-drag-file-not-working?forum=vcgeneral

“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.


#6

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 ).


#7

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


#8

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.


#9

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.


#10

“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) ….


#11

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.