Can not find Oracle home.

Can not find Oracle home.

Postby genesplitter » Sat 08 Aug 2009 00:18

I went through the sample console application and sucessfully reverse generated a couple example tables from my Oracle database, however when running the example code:

CrmDemoDataContext context = new CrmDemoData.CrmDemoDataContext();

var query = from it in context.PROPOSALs
orderby it.PROPOSAL_SERIAL_NUMBER
select it;


foreach ( PROPOSAL p in query)
{
Console.WriteLine("{0}", p.PROPOSAL_SERIAL_NUMBER);
}

I get the following error on the foreach...

"Can not find Oracle home."

This seems a bit surprising because there was no issue finding the hundreds of tables/views when I reverse engineered the database.

Does devart talk to the database via a different path when using the DevArt LINQ to SQL Modeling tool vs from plain code?
genesplitter
 
Posts: 7
Joined: Sat 08 Aug 2009 00:08

Postby AndreyR » Mon 10 Aug 2009 11:24

We use the same connection string to connect the database in both cases.
Please make sure that you use the same connection strings to connect.
One more idea: the problem may be associated with 32/64 bit compatibilities, please make sure you use the proper Oracle client.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle