connection string of oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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

ken said:
dear all,

I use OracleConnection conn = new OracleConnection("Data
Click to expand...
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
Click to expand...
make a new user to connect?
 
Back
Top