Oracle

Re: Oracle membership provider

jem3hall — Tue, 08 Sep 2009 11:47:15 GMT

Take a look at www.learn-Oracle-OLAP.com/ . It supports all the providers for Oracle. Also, there is a web service edition, which is perfect when the IIS server does not have direct access to the database

Re: Oracle membership provider

chrishulbert — Tue, 11 Aug 2009 03:14:05 GMT

I've been looking into this problem further, and you simply need to grab all the appropriate DLL's from the same downloaded version of ODP.Net and put them in the same folder as your Exe file, because ODP.Net is fussy about not mixing version numbers, which is the problem you're seeing (either that or the oci.dll is totally missing, in which case it annoyingly gives the same error).

I've explained how to do this here: http://splinter.com.au/blog/?p=156

Here's the gist of it though:

* Download http://www.oracle.com/technology/software/tech/windows/odpnet/index1110710beta.html

* Unzip the file

* Unzip all the JAR's in it

* Grab these dll's that were just unzipped:

oci.dll (renamed from 'oci.dll.dbl')

Oracle.DataAccess.dll

oraociicus11.dll

OraOps11w.dll

orannzsbb11.dll

oraocci11.dll

ociw32.dll (renamed from 'ociw32.dll.dbl')

* Put all the DLLs in the same folder as your C# Executable

I've explained how to do this here: http://splinter.com.au/blog/?p=156

Here's the gist of it though:

* Download http://www.oracle.com/technology/software/tech/windows/odpnet/index1110710beta.html

* Unzip the file

* Unzip all the JAR's in it

* Grab these dll's that were just unzipped:

oci.dll (renamed from 'oci.dll.dbl')

Oracle.DataAccess.dll

oraociicus11.dll

OraOps11w.dll

orannzsbb11.dll

oraocci11.dll

ociw32.dll (renamed from 'ociw32.dll.dbl')

* Put all the DLLs in the same folder as your C# Executable

Re: Oracle membership provider

juanformoso — Thu, 19 Jun 2008 12:55:46 GMT

sumathi:

Michael,

Thanks for your support so far. I ran into another issue. Please let me know if you are aware of the problem/solution. Thankx once again.

Steps I followed:

1. I have set up the membership schema in Oracle Database

2. I have modified the config file to refer to the oracle membership provider

3. I have set up the front end with the sample login pages

I am getting a type initializer error with Oracle.DataAccess.dll.

1. I used the dll provided with RAdical development. I get the following error

Provider is not compatible with Oracle Client version

The provider is not compatible with the version of Oracle client

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

2. I removed this dll from the project, and added the Oracle.dataacess.dll which was present in my machine (ODP.net), I get the following mismatch error.

Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

I am positive that the error is due to the Oracle DataAccess dll. But how do I fix this one. Which dll should I use? If I use the radical, i get the type mismatch error. If i use the ODP.net provided dll, I get the could not load file error. I am confused at this stage.

Thank you very much for your support. I appreciate your help!

Warm Regards,
RS

I'm having this exact problem... any news on a fix / workaround?

Re: Oracle membership provider

diehardguy — Thu, 24 May 2007 16:18:16 GMT

I have made a implemented a custom Oracle Provider and you can download at my website including SQL scripts.

www.dotnetfx.co.uk

Cheers,

Damian

Re: Oracle membership provider

lihian1 — Fri, 04 May 2007 20:10:43 GMT

Where exactly is the solution located on the webpage? I could not find it. Please advise. Thx.

Re: Oracle membership provider

jroland122 — Fri, 09 Feb 2007 14:58:32 GMT

We asked for a trial software from CNUX and it was really easy to setup. It took about an hour to set everything up.

We tested a bit and it seems solid. No problems found so far. Consider the support that comes with the software and it will cost us a lot more to maintain our own code, our manager has decided to use the CNUX providers. To management it all comes down to what makes financial sense.

Re: Oracle membership provider

Caddre — Wed, 31 Jan 2007 18:57:15 GMT

jroland122:
I meant thx to both Caddre and iluvasp.

I am glad I could help, I am from data so when a company says call for price quote it is not going to cost $150 so if you need it David's converter can do it for you. I know even if you did not buy his tool and post the conversion problem in the language forum here he will help.

http://forums.asp.net/thread/1556772.aspx

Re: Oracle membership provider

jroland122 — Wed, 31 Jan 2007 18:49:12 GMT

I meant thx to both Caddre and iluvasp.

Re: Oracle membership provider

jroland122 — Wed, 31 Jan 2007 18:47:56 GMT

Thx. Let's see if I can digest what you are saying and try it out.

Re: Oracle membership provider

iluvasp — Wed, 31 Jan 2007 15:49:46 GMT

Google is your friend. Found this one http://www.cnux.ca/oracleproviders_productpage.html. I hope it helps.

Re: Oracle membership provider

Caddre — Wed, 31 Jan 2007 15:17:00 GMT

jroland122:

I saw that before but we need something more robust. We develop in C#, and the providers must be thread safe and unicode (multilingual) compatible. We also plan to use it with SharePoint.

The transaction controls are also missing from Ben Rush's code.

You can add transaction in ADO.NET or PL/SQL code block and Unicode get an Oracle book and look up collation because the datatypes are already in Unicode it is not complicated just remember to use .NET compatible collation which is UTF-16. In SharePoint you will be adding it as a class library develop what you need in SQL Server 2005 with the correct collation and use SSIS to migrate to Oracle it is not complicated. So here is your option look for commercial one if it cost more than $150 buy a code converter and convert it. Hope this helps.

Re: Oracle membership provider

jroland122 — Wed, 31 Jan 2007 14:43:25 GMT

I saw that before but we need something more robust. We develop in C#, and the providers must be thread safe and unicode (multilingual) compatible. We also plan to use it with SharePoint.

The transaction controls are also missing from Ben Rush's code.

Re: Oracle membership provider

Caddre — Tue, 30 Jan 2007 21:11:52 GMT

jroland122:

I have already asked this question on another thread, but I'll ask here too anyway. My boss wants to implement the complete providers (Membership, Role, Session State, Web Event, etc.) in Oracle. After doing some research it appears to be a trememdous job. Does anyone know of a good commercial one that we can buy off the shelf?

If you write VB.NET you are in luck because someone have already created all the providers, try the link below for details. Hope this helps.

http://www.ben-rush.net/source/OracleProviders/

Re: Oracle membership provider

jroland122 — Tue, 30 Jan 2007 20:58:52 GMT

I have already asked this question on another thread, but I'll ask here too anyway. My boss wants to implement the complete providers (Membership, Role, Session State, Web Event, etc.) in Oracle. After doing some research it appears to be a trememdous job. Does anyone know of a good commercial one that we can buy off the shelf?

Re: Oracle membership provider

mlasell — Thu, 18 Jan 2007 16:10:29 GMT

Did you download the latest oracle client?

Michael