Forum Stats

  • 3,768,552 Users
  • 2,252,809 Discussions
  • 7,874,617 Comments

Discussions

How do I connect by proxy using Visual Studio 2019 and ODT

user10594416
user10594416 Member Posts: 5 Blue Ribbon

So I have to connect by proxy with my personal account to various functional schemas. This is easy in sqlplus with syntax like

sqlplus myuser[funcschema]/[email protected]


Whilst in ODT there are proxy user and proxy password fields in the Advanced Settings for a connection, I've found no combination that works so far. I only have the single password (for my account), but the form requires that the "Password" field is populated. However, if that is completed, and the "Proxy Password" left blank I get an "ORA-01005: null password given; logon denied" error. If I use my password for BOTH, I get "ORA-01017: invalid username/password; logon denied". So am confused as how this can work. I can connect by proxy without issue in SQL*Plus and SQL*Developer.


I think the issue is that it will not allow you to leave the password field as empty - you cannot save a connection like that, but believe that should be the case in this scenario. In VS Code, there is a similar tool that allows that kind of config, and it works fine.

Answers