How to connect to oracle9i with sys user using .net

[pradip010189]

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.

[Frinavale]

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

[pradip010189]

I do code like this ..

Dim con As New OracleClient.OracleConnection("Data Source=pradip;User ID=sys;Password=compengg;Unicode=True")
Dim ad As New OracleClient.OracleDataAdapter("select * from " + TextBox1.Text, con)
Dim ds As New DataSet()
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