connection string - specify oracle home?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
paolohu
Posts: 4
Joined: Sat 05 Jun 2010 00:20

connection string - specify oracle home?

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

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

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

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

Post by paolohu » Thu 10 Jun 2010 23:57

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

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 11 Jun 2010 16:54

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

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

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

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. :D

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

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.

Post Reply