I'm Building ASP.NET web application with Oracle 10g DB
when I'm trying to create a new ORM domain module and create a new connection with Oracle an Exception appears
with the following details :
Connection Error, Exception Telerik.OpenAccess.Exceptions.DataStorExcpetion, Details: Database driver installation problem: Cannot use factory for oracle..........................................Could not load file or assembly 'Oracle.DataAccess, version= 22.214.171.124, Culture = neutral, PublicToken= 89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
File name: 'Oracle.DataAccess, version= 126.96.36.199, Culture = neutral, PublicToken= 89b483f429c47342' at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory..ctor()...............................
I'm using vs2008
10 Answers, 1 is accepted
You have to install the Oracle ODP.NET driver on your machine. To check you can have a look into the GAC (c:\windows\Assembly) and see which version of the Oracle.DataAccess you have installed.
the Telerik team
in fact the oracle dataaccess client was installed but I had to use gacutil to register the dll in the GAC
when I did it worked just fine.
thank you very much
I think this is looking for the 11g Oracle Data Access even though we have only installed the 10g client. I should be able so specifiy what assembly I need by putting an entry in the web.config file but ORM is not using that when you connect to reverse the database. Any ideas on how I can tell Telerik ORM to use 10g instead of 11g?
Some more info:
Oracle databases can be accessed by two database drivers. The first is the Microsoft driver that comes with the .NET installation, which is the default. The other is the .NET ODP driver from Oracle. Telerik OpenAccess ORM refers to the ODP driver version 188.8.131.52.
The Microsoft driver works with the Oracle 10, Oracle 10 XE and the Oracle 11 native client, the ODP works with Oracle 10 R2 and the Oracle 11 native client.
The drivers can be downloaded from here.The minimal version should be 10.2.0.2.20.
For Oracle, you will need an account on an active database. Telerik OpenAccess ORM will automatically create/update the class schema information.
Check with your RDBMS administrator if you need help.
Sigh...I will do that under protest as this will now need full regression testing on all my applications.
I am on the newest version of ORM now (and from what I see, there are a few great changes!).
Good to hear that you have now a working setup. We are usually adding great stuff to our new versions ;) Please stay tuned for all the features in the Q1 release.
the Telerik team