 |  |  |  |  |  |  |  |
connecting VB to a SYSDBA user in Oracle
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
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.
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.
|
Similar Threads
- Urgent help for BSc Computing for Business degree Final year project (IT Professionals' Lounge)
- How to Connect MySQL from JSP Page (JSP)
- how to connect vb6.0 to oracle 9i (Visual Basic 4 / 5 / 6)
- beginning oracle (Oracle)
- connecting jsp with oracle database (JSP)
- help with JDBC oracle9i (Java)
- Oracle Connection (Java)
- Connecting to Oracle (Java)
- Connecting via Winmatrix to Access (ASP.NET)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: soundcard output
- Next Thread: Simple Array Calculator Help
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
