connection string - specify oracle home?

connection string - specify oracle home?

Postby 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.
paolohu
 
Posts: 4
Joined: Sat 05 Jun 2010 00:20

Postby 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/docs/Devart.Data.Oracle~Devart.Data.Oracle.OracleConnection~Home.html

At design-time, e.g., in the connection dialog, you can select the Oracle client in the 'Home' drop-down list.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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
 
Posts: 4
Joined: Sat 05 Jun 2010 00:20

Postby 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
 
Posts: 4
Joined: Sat 05 Jun 2010 00:20

Postby paolohu » Thu 10 Jun 2010 23:57

nevermind - i figured out - i can just add ";home=oraclehomename" to the connection string
paolohu
 
Posts: 4
Joined: Sat 05 Jun 2010 00:20

Postby Shalex » Fri 11 Jun 2010 16:54

We will post here when the Enterprise Library 5.0 support is implemented.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44

Postby 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
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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. :D
cerealjoe
 
Posts: 3
Joined: Mon 09 Aug 2010 16:47

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle