Drive missing

[Lest4t]

Hi all,

First of all, sorry for my really bad english, I usually speak french ...

I am using PL/SQL developper v10 on a Win7 64 bit.

I had to install an Oracle 11G Database ExpressEdition 32 bit so I can now use PL/SQL Developper on that OS ...

My problem now is that there are several Drive missing in PL/SQL Developper. As an exemple, if i try to save a sql file on my computer, half of my drive mapped are not available to save the file.

But the worst is that i can't execute a sql file under the command line if the file is under one of the missing drive. I got the error "Error reading file" because PL/SQL Dev don't see the given Drive but those missing drive really exist on my machine ....

whats wrong??

Why some drive are missing like that??

Did someone had the same problem?? How can i fix it??

 

[Hilarion]

Your English is quite fine. At least I had no problem understanding it (and I also do not speak English natively and I do not know French at all).

I had similar issues with another application. It may apply to your case too.

Are you having the User Account Control (UAC) turned on and running the PL/SQL Developer (PLD) using elevated privileges ("Run as an administrator")? In that case it may mean that you have your drives mapped only for the un-elevated environment and any application using elevated privileges will not be able to see nor use the mapped drives.

As far as I know, you do not need the elevated privileges to run the PLD. I'm using it just as you do on Windows 7 64-bit, have UAC turned on and am able to use the PLD without elevating its privileges.
If for some reason you have to use elevated PLD, you may consider launching it through a Windows Command line (elevated) in which you'd first map your drives (using "net use" commands in an *.cmd script) and then start the PLD. (I used similar approach for altering environment variables before Allround Automations introduced an ability to change them in PLD execution or configuration parameters.)

PS.: You do not have to install an Oracle Database on your machine to use PLD. If you need an Oracle DB on your machine, it does not have to be 32-bit edition. What you need for PLD is a 32-bit Oracle Client (it's included in an Oracle DB install, but is also available independently and you may even use an Oracle Instant Client, which does not even require installation).

 

[Lest4t]

You are great Hilarion!

You solve the problem, I just unchecked the combo-box "run as admin" and now I can see all my drives.

Thanks alot!

PS. took note for the instant client instead of the full DB installation, thanks for that too.

Have a nice day!