have a look here for your connection string:

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

use the System.Data.OleDb namespace ...

Marc,

Check out the Oracle Data Provider (ODP.Net)

http://www.oracle.com/technology/tech/windows/odpnet/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

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.

*************************************************

I did what you should have done: I searched google first:
http://www.oracle.com/technology/tech/dotnet/aspnet/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