hello, Im using VB6 and connecting to an Oracle 9i db via ADO.
My tables are stored in the SYS folder and am having a problem while accessing these from VB.
While connecting to Oracle as username: sys, pswd: change_on_install, the following error message is seen:
'Test connection failed because of an error in initialising provider. ORA-28009:connection to sys should be as SYSDBA or SYSOPER.
I have tried using SYSDBA as the username and change_on_install as pswd, this doesn't work either. I have tried using the pwd: change_on_install_as_sysdba for the same username, but this doesn't work either.
I need to access and make changes to my tables stored in SYS using VB. Please help. Thank you.
