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'?
I am writing an automated installation script that requres DBA access in order to create user accounts (schemas), tablespaces, etc. I need to log into Oracle as 'SYS' and the application uses ODBC to connect to the database.