Connectionstring question for dotConnect entity app

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
dharric
Posts: 3
Joined: Sun 08 Jan 2012 03:09

Connectionstring question for dotConnect entity app

Post by dharric » Mon 09 Jan 2012 18:36

Hello my connectionstring right now for an oracle based app using dotConnect is connectionString="metadata=res://*/MiddleTierModel.csdl|res://*/MiddleTierModel.ssdl|res://*/MiddleTierModel.msl;provider=Devart.Data.Oracle;provider connection string="User Id=PM_LIVE_OWN;Password=dev;Server=ORADEVPIM;Home=oraclient11g_home32;Persist Security Info=True""

I noticed the Home attribute and I'm not quite sure if this is pointing to the correct location on my box. How can I confirm this? I am getting the error Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server

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

Post by Shalex » Mon 16 Jan 2012 14:01

dharric wrote:I noticed the Home attribute and I'm not quite sure if this is pointing to the correct location on my box. How can I confirm this?
1. Open your registry editor (execute "regedit" in command line), navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\BRANCH_OF_YOUR_CLIENT, and make sure that "oraclient11g_home32" corresponds to the content of the ORACLE_HOME_NAME variable.
2. Place the content of the ORACLE_HOME variable on the first position in the PATH variable of your operating system.
3. Make sure that capacity (x86 or x64) of your application and capacity of your Oracle client are the same.

If this doesn't help, refer to http://www.devart.com/forums/viewtopic.php?t=15271 .

Post Reply