property OracleConnection.Schema

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
darrin
Posts: 7
Joined: Wed 11 Apr 2007 12:13

property OracleConnection.Schema

Post by darrin » 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

Code: Select all

"Alter session set schema = USER1"
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?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 09 Jul 2008 13:56

Hello, Darrin.

We plan to implement the Schema property in the OracleConection class, but no estimated timeframe is available.

As for setting schema for OracleConnection used by ASP.NET Providers, there is no alternative way at the moment.

Regards, Andrey.

Post Reply