Hi,
I'm trying to use OLEDB VBO to conenect to Racle DB. Following i my connection string. While executing "Open" Action to open connection in Oracle, it is throwing me the error - "ora-28009: connection as sys should be as sysdba or sysoper". Please help!
Connection String - (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.44.78.12)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SRVICE_NAME=orcl)))
User Id=sys;Password=Oracle123;DBA Privilege=SYSDBA;
------------------------------
Mili Doshi
Business Consultant
Persistent Systems Ltd
Asia/Kolkata
------------------------------