473,657 Members | 2,477 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to connect to oracle9i with sys user using .net

2 New Member
I want to get the access using the sys user of the oracle9i from vb.net application but i cant connect using this username.

I got the error like this
connection to sys should be as sysdba or sysoper.
so what should i do for it?


Pradip.
Mar 31 '10 #1
2 1593
Frinavale
9,735 Recognized Expert Moderator Expert
I'm not sure if you can access the system user for the database...

Anyways, you should post the code that is involved in the error so that we can see what your doing.

-Frinny
Mar 31 '10 #2
pradip010189
2 New Member
I do code like this ..

Expand|Select|Wrap|Line Numbers
  1. Dim con As New OracleClient.OracleConnection("Data Source=pradip;User ID=sys;Password=compengg;Unicode=True")
  2. Dim ad As New OracleClient.OracleDataAdapter("select * from " + TextBox1.Text, con)
  3. Dim ds As New DataSet()
  4. ad.Fill(ds, "stable")

here i changed the password of the sys user at install.
by default it is "change_on_inst all"


using this code i got the error is "connection to sys should be as sysdba or sysoper."

but if i write the user name as sys /as sysdba
then it will display the error is "username and password is incorrect,acces s denied".

reply..

Pradip
Apr 1 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1938
by: Oracle Instructor | last post by:
Hi All, Edmonds Community College is now offering the Oracle Development Courses, which include Oracle9i SQL, Oracle9i PL/SQL, Oracle9i Forms, and Oracle9i Reports. These courses will provide you with the skills needed to pass the Oracle Certification tests. Because they are credit classes (State Funded), you will save thousands of dollars by taking these courses with Edmonds Community College. Here are the Oracle courses that are...
3
10975
by: Nathan Sokalski | last post by:
When I attempt to run a form created with Oracle9i Forms Builder I receive a dialog box asking for the following info: User Name: Password: Database: I obviously know my User Name and Password, and I assume that the value I use for Database is the value found in the tnsnames.ora file (in my case, ORCL). However, when I do this I receive the following error:
8
14369
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about the database when I log in - Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options
0
955
by: SD007 | last post by:
I am trying to connect Oracle9i with jdk1.4, but it is giving error at- Class.forName("Oracle.jdbc.driver.OracleDriver"); The error is- java.lang.ClassNotFoundException:Oracle.jdbc.driver.OracleDriver. please help me.
4
3213
by: gopiinamadar | last post by:
hi i want to connect a jsp file with oracle9i server. initially i used MS Access with jsp and i will copy all jsp and html pages in webapp/root files and run apache tomacat5.5, it works fine.. but now i want to connect it with oracle9i server. so what i have to do or where i have to copy the files(jsp & html) or any other method? please help me thanks
2
1351
by: charlesa | last post by:
hi all I long back using oracle9i . But today suddenly power is gone and get back With in second . so my system is going to restart . After that I am not able To access even Scott user also Please give me the result for above condition
11
2368
by: Mishika9486 | last post by:
Hi pals.. i hav developed an application in vb nd am tryin to connect using oracle.. it gives the following error using ADODC and ODBC "test connection failure because of an error in initializing provider.driver for oracle]" please help..
8
4525
by: boss1 | last post by:
i have created a database named:Rezgroup and i have already developed some pages but i dont know what is the code to connct Php and oracle.Thats why i can not access the database. so far i have come up with the code is: <?php set conn=Server.CreateObject("ADODB.Connection") conn.Provider="MSDAORA " conn.Open "c:/webdata/Rezgroup" set rs=Server.CreateObject("ADODB.recordset") rs.Open "nwd_info", conn
1
1567
by: Renilkumar | last post by:
Hi, I am using .net2.0,oracle9i with odp.net9. When a password is expired, I am forcing the user to enter the new password and once it sets I am redirecting the user to the login page to login with their new password. But If I use the old password it shouldn't allow me to login right. Instead its allowing me to login with my old password. Even with the new password its logging me in. Only after sometime the oldpassword really expires. Any...
4
2011
by: eeriehunk | last post by:
Hi, Please give me a lead on how to connect Oracle 9i which is on a unix machine to MS SQL Server and access its data. Does Oracle9i or TOAD have any inbuild functionality to make connections and access data.
0
8844
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8742
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8518
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7354
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6177
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5643
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4173
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4330
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1734
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.