ORACLE CONNECTION

Question

Hi Guys, I want to use an oracle connection in Microstation. 
 My Oracle Client is here : c:\oracle\product\11.2.0\client_1 . 
 MS_ORACLE_HOME also is set to c:\oracle\product\11.2.0\client_1. 
 As this client is NOT my preferred client for other programs that connect to Oracle, it is not published in the PATH Variable or at least not published first place. 
 When I want to connect, using SESSION DEBUG ON , then MS shouts unable to load c:\oracle\product\11.2.0\client_1\bin\orasql11.dll 
 This is urgent. Could anyone please tell me whats going on? 
 Regards, Stefan.

Nelson Hobdell · Accepted Answer

We've found Stefan's case to be representative of a problem within MicroStation, when multiple Oracle clients are installed and included within the OS path definition. This occurs despite appropriate definition of MS_ORACLE_HOME, when the/an undesired client path takes precedence within the OS path statement. i.e. : is listed first. Defect #87352 has been filed to address this issue. 
 The hallmark of the issue is revealled within a session debug of the failing connection. Herein we see that EXTSERVER has located the specified Oracle client (line 8), but is unable to load the files subsequently requested (line 10), despite thier presence in that location: 
 8 EXTSERVER: Found Oracle Client: c:\oracle\product\11.2.0\client_1\bin\oraclient11.dll 9 MDL:CallBack for DebugMessage 10 EXTSERVER: Unable to load c:\oracle\product\11.2.0\client_1\bin\orasql11.dll 
 
 The workaround for the problem is to reorder, or completely remove the undesired client path from the path statement utilized by the MicroStation session. 
 This can be accomplished most simply by launching MicroStation from the OS command line, *.bat or *.cmd file as may be appropriate, with the modified PATH= statement. In the example below, we remove an undesired Oracle 10.2.0 client, to allow succesfull connection to the Oracle 11.2.0 client: 
 
 (reorder) 
 SET PATH=C:\oracle\product\11.2.0\client_1\bin;C:\oracle\product\10.2.0\Ora102010_32\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem 
 (removal) 
 SET PATH=C:\oracle\product\11.2.0\client_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem 
 then: 
 CALL "C:\081109357 MicroStation V8i (SELECTseries)\MicroStation\ustation.exe"