Hi,

I have installed Oracle client 10.2.0 on Vista business following the procedure on this blog:
http://cshay.blogspot.com/2007/02/getting-ready-for-windows-vista.html
You will need access to Metallink!

Additionally have installed PL/SQL developer ver. 7.0.3.1123 successfully, however the folloiwng registry entries were not defined, and had to import them manually into Vista in order to install the add-ins (BE extender, Active Query Builder, PlSQL doc).

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer]
@="PL/SQL Developer file"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\DefaultIcon]
@="c:\\program files\\plsql developer\\plsqldev.exe,1"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell\Open]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell\Open\Command]
@="\"c:\\program files\\plsql developer\\plsqldev.exe\""

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell\Open\ddeexec]
@="[Open(\"%1\")]"

Regards,


Jesmond

If you are using the default setup with User Account Control (UAC) then try right-clicking on PL/SQL Developer short cut and select 'Run as Administrator'. If you are not logged in as an administrator user then you will be prompted for an administrator username and password. Even if you are logged in as an administrator then the programs are not executed with administrator privileges unless you select 'Run As Administrator'.

This procedure allowed me to run PL/SQL Developer successfully. And SQL*Plus too. My problem was actually with SQL*Net as stated earlier. The resulting error in PL/SQL Developer was the before mentioned empty message box with and OK button.

If UAC is disabled and you are logged in as an local administrator, I don't think this is required.

Bo Pedersen

I am experiencing the same issue with v.6 of PL/SQL. The different thing is, i CAN run sqlplusw.exe without having to run it as administrator. But PL/SQL Developer, if not run as Admin, will have the same problem above, ... just a tiny little message box comes up with no message and no title, and just an OK button. But, if i run it as Administrator it works perfectly fine.

Everything was installed under Administrator account. Using PL/SQL Developer 6.0.6.947, Oracle 10g Client, on Vista Ultimate (RTM).

Is there any ideas or fixes on this yet? I tried the debug switch mentioned above, but also, i do not get any debug output file, although i do have full permissions to the PL/SQL Developer directory.

Does this empty error message also occur if you do not log on?

no, if i cancel the logon dialog, then i do not get the msgbox. Then if i try to log on from inside the app after it loads, i get a small msgbox saying simply "Could not logon as myusername".

If i put the debug switch back on and try loggin on from inside like that though, i still do not get any debug file, sorry. :-\

Try 'Run as Administrator'. A normal user on Vista does not have access to the Program Files directory, HKLM in the registry etc. Both SQL*Net and PL/SQL Developer assumes access to that.

And with UAC, programs started by a local administrator does not execute with administrator privileges.

I got pass the empty dialog box by using 'Run as Administrator'. But now file extension associations and drag'n'drop does not work since a program with lower privileges (Explorer) cannot access a program with higher privileges (PL/SQL Developer) .

Bo Pedersen

Right clicking on the PL/SQL Developer shortcut and selecting "Run as Administrator" worked for me.

FYI I am running PL/SQL Developer 7.1.1.1339 with Oracle client 10.2.0.1.0.

Yah, RaA worked for me too; Thanks!

I was just informed of disconencts even when running as admin. The disconnects do not occur with SQL*Plus from the same client. Anyone experienced this?

It's not necessary to run as administrator when using Oracle Database Client 10.2.0.3 for Vista. See http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html

Bo