Is ASP.NET only for SQL Server Users?

[Wannano]

Does anyone know a simple way to configure Oracle as the datastore for the
Session State of an ASP.NET application? Not all the Oracle users works with
Java or PHP and not all ASP.NET developers work with SQL Server.

Marc Biotteau

[Barrie Wilson]

"Wannano" <wa*****@wannano.comwrote in message
news:OR*************@TK2MSFTNGP02.phx.gbl...

Does anyone know a simple way to configure Oracle as the datastore for the
Session State of an ASP.NET application? Not all the Oracle users works
with Java or PHP and not all ASP.NET developers work with SQL Server.

Marc Biotteau

have a look here for your connection string:

http://www.connectionstrings.com/?carrier=oracle

use the System.Data.OleDb namespace ...

[Dan Gartner]

On Dec 4, 8:04 pm, "Wannano" <[e-mail]:

Does anyone know a simple way to configure Oracle as the datastore for the
Session State of an ASP.NET application? Not all the Oracle users works with
Java or PHP and not all ASP.NET developers work with SQL Server.

Marc Biotteau

Marc,

Check out the Oracle Data Provider (ODP.Net)

http://www.oracle.com/technology/tec...net/index.html

These are tools released by Oracle, and they are optimized for their
database. You would then have to implement your own session state
store provider. For more info on that, check out
http://msdn2.microsoft.com/en-us/library/ms178587.aspx

Hope this helps,
-Dan

[Cowboy \(Gregory A. Beamer\)]

You already have advice on connecting to Oracle, so I will not rehash that.

For Session State? I would imagine you would have to roll your own. Have not
checked if there is an easy provider model for that. I would look at the
classes in the framework that deal with session state and see if there is a
way to inherit. You can then reverse engineer the SQL Server stuff and alter
it to use ODP.NET or OracleClient.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************
| Think outside the box!
|
*************************************************
"Wannano" <wa*****@wannano.comwrote in message
news:OR*************@TK2MSFTNGP02.phx.gbl...

Does anyone know a simple way to configure Oracle as the datastore for the
Session State of an ASP.NET application? Not all the Oracle users works
with Java or PHP and not all ASP.NET developers work with SQL Server.

Marc Biotteau

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

I did what you should have done: I searched google first:
http://www.oracle.com/technology/tec...net/index.html

--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com

"Wannano" wrote:

Does anyone know a simple way to configure Oracle as the datastore for the
Session State of an ASP.NET application? Not all the Oracle users works with
Java or PHP and not all ASP.NET developers work with SQL Server.

Marc Biotteau