Member Avatar for nisrin
nisrin 0 Newbie Poster

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.

  • 1 Contributor
  • 0 Replies
  • 67 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.