Can not find Oracle home.

[genesplitter]

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?

[AndreyR]

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.