connection string of oracle


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

Advertisements

G

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
 
Ad

Advertisements

R

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

ken said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top