property OracleConnection.Schema

property OracleConnection.Schema

Postby darrin » Tue 08 Jul 2008 08:59

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?
Posts: 7
Joined: Wed 11 Apr 2007 12:13

Postby 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.
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Return to dotConnect for Oracle