This discussion is archived
6 Replies Latest reply: Mar 5, 2013 8:19 PM by 995020 RSS

Oracle ODBC as user works but fails as 'SYS'

tx103108 Newbie
Currently Being Moderated
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'?

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points