6 Replies Latest reply on Mar 6, 2013 4:19 AM by 995020

    Oracle ODBC as user works but fails as 'SYS'

      Windows 7
      Oracle XE 11gR2

      From Windows, I can successfully create and connect with a system data source using an user Oracle account.
      But when doing then same configuration process I can not create or connect using the 'SYS' account.
      Understandably, I get the error 'ORA-2009: connection as SYS should be as SYSDBA or SYSOPER'.

      What is the solution to creating an ODBC DSN for the user 'SYS'?