Oracle Schema name in connection string

2413
Views
1
Answers

How do I include a schema name in a connection string in .net

edit | flag
William Patrick
Asked on: Oct 10, 2011 at 8:10PM

1 Answers

63
4
63

You should do something like this..

The schema is synonymous with user in oracle - you don't specify a schema in the connection string - you specify a username. Each user may or may not be an owner of database objects (tables, views, procedures, etc). To access the objects owner by another user (schema) you can either:

  1. Use a fully qualified name: SCHEMA.OBJECTNAME

Specify in web.config like..

add name="ConStringname" connectionString="Data Source=DBName;User ID=Schema_name;Password=*******;"/>

You can see more here

edit | flag
Gokul A
Answered on: Oct 10, 2011 at 8:20PM

Post your Answer

Search

Welcome to Ask Amoeba!
This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions.
Learners, beginners, Experts stop and share your knowledge and ideas!

Browse Categories

Browse Tags