connection string - specify oracle home?

paolohu · Post by **paolohu** » Thu 10 Jun 2010 03:37

I have two homes - one 32 bit and one 64 bit. If I run OraDeveloper Studio - it connects fine if I manually choose the correct home (64 bit).

Now if I run my application in Visual Studio - it runs as 32bit. Which then gives me an error because the oracle dlls are in the incorrect format.

Is there a way to specify in the connection string (or other) which home to use the same way there is in the OraDeveloper studio (or TOAD or anything else)?

I cannot use direct mode because we are using RAC.

StanislavK · Post by **StanislavK** » Thu 10 Jun 2010 08:57

Please specify whether you are connecting to the server at run-time or at design-time. At run-time you can specify the Home property of the OracleConnection object or add the Home parameter to the connection string:
http://www.devart.com/dotconnect/oracle ... ~Home.html

At design-time, e.g., in the connection dialog, you can select the Oracle client in the 'Home' drop-down list.

paolohu · Post by **paolohu** » Thu 10 Jun 2010 21:37

at run-time - it looks like that property may work - i'll give it a shot

thanks

On a side note - any timelines for enterprise library 5 support?

paolohu · Post by **paolohu** » Thu 10 Jun 2010 23:17

And how about when using the enterprise library component - it doesn't look like there is a home property available there?

paolohu · Post by **paolohu** » Thu 10 Jun 2010 23:57

nevermind - i figured out - i can just add ";home=oraclehomename" to the connection string

Shalex · Post by **Shalex** » Fri 11 Jun 2010 16:54

We will post here when the Enterprise Library 5.0 support is implemented.

StanislavK · Post by **StanislavK** » Thu 29 Jul 2010 13:12

We've released dotConnect for Oracle 5.70.152 in which Enterprise Library 5 is supported. The new build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (provided that you have an active subscription):
http://secure.devart.com/

For more information on improvements and fixes available in the 5.70.152 version, please refer to
http://www.devart.com/forums/viewtopic.php?t=18588

cerealjoe · Post by **cerealjoe** » Wed 11 Aug 2010 03:31

paolohu wrote:at run-time - it looks like that property may work - i'll give it a shot

thanks

On a side note - any timelines for enterprise library 5 support?

How can you work that property? I hope that you should really give it a shot. Hoping to see your work.

StanislavK · Post by **StanislavK** » Thu 12 Aug 2010 14:13

cerealjoe, please tell us if you encounter any problems with using the Home connection string property. If yes, please describe these problems in details, i.e., specify the actions you are trying to perform and the results to which this leads.