connecting VB to a SYSDBA user in Oracle

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Reply

Join Date: Jan 2006
Posts: 18
Reputation: nisrin is an unknown quantity at this point 
Solved Threads: 0
nisrin nisrin is offline Offline
Newbie Poster

connecting VB to a SYSDBA user in Oracle

 
0
  #1
Apr 22nd, 2007
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC