property OracleConnection.Schema
Posted: Tue 08 Jul 2008 08:59
Hello.
Do you plane realise property Schema in class OracleConnection, like in ODAC.VCL?
I'm using Ora.Net ASP Providers in my Web application. When application starts, provider try to select autentification data from server, but error raising, becouse ASPNET tables exits in schema USER1, bun I connecting to database as USER2. In my desktop Application i made a descendant from OracleConnection, in witch execute
But in web application i cann't use my descendant, becouse all Provider use oracleProviderFactory.
Does exists another way to set schema for oracleConnection, which used by ASPProviders?
Do you plane realise property Schema in class OracleConnection, like in ODAC.VCL?
I'm using Ora.Net ASP Providers in my Web application. When application starts, provider try to select autentification data from server, but error raising, becouse ASPNET tables exits in schema USER1, bun I connecting to database as USER2. In my desktop Application i made a descendant from OracleConnection, in witch execute
Code: Select all
"Alter session set schema = USER1"Does exists another way to set schema for oracleConnection, which used by ASPProviders?