connection string of oracle

[Guest]

dear all

I use OracleConnection conn = new OracleConnection("Data Source=myDataSource; User Id=sys; Password=myPassword;")
however it said It can't connect to db since ... sysdba ....
I don't know how to connect, is it the problem of conn or is it need to make a new user to connect?

 

[Guest]

Do you hae Oracle client set up on your machine and is there a TNSNames entry pointing to the Oracle DB instance?

Your connection string should look similar to

"Provider='MSDAORA.1';User ID=bpxp;Data Source=PUR;Password=bpxp"

This is using the Microsoft Data Access Provider for Oracle ODBC

 

[Roy Fine]

Ken

you can not connect using sys! pick another account and try again. sys
requires as sysdba modifier -- if you really need to connect as sysdba, then
switch to the Oracle Data Provider for .NET.

regards
roy fine

dear all,

I use OracleConnection conn = new OracleConnection("Data

Source=myDataSource; User Id=sys; Password=myPassword;");

however it said It can't connect to db since ... sysdba .....
I don't know how to connect, is it the problem of conn or is it need to

make a new user to connect?