[THIN] Re: Xenapp 6, Office 2010 and Oracle ODBC

  • From: "Jeremy Saunders" <jeremy@xxxxxxxxxxxxxxxxxxxx>
  • To: <thin@xxxxxxxxxxxxx>
  • Date: Thu, 9 Jun 2011 21:02:54 +0800

It depends on how the app is making the ODBC call. It's probably looking for
the driver in the wrong folder. You could only really test this will Process
Monitor, or something like that.

You can only use c:\windows\syswow64\odbcad32.exe because this is where the
driver is loaded. Try copying the driver registry information from here
"HKLM\SOFTWARE\Wow6432Node\ODBC" to here "HKLM\SOFTWARE\ODBC". Then you'll
be able to use c:\windows\system32\odbcad32.exe.

I deployed Oracle 10g Client on a recent XenApp 6 deployment. Version
10.2.0.4 is a minimum requirement to be able to installed and registered
correctly on Windows 2008 R2. You will then need to apply the 10.2.0.5 patch
set.

Cheers,
Jeremy.

-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf
Of David
Sent: Thursday, 9 June 2011 8:16 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Xenapp 6, Office 2010 and Oracle ODBC

Yes, 32 bits oracle and office 2010 as well.

Greg, I have tried this, installing into 'program files', but I've got the
same.


> You are loading the 32 bit oracle client.  Correct?
>
> On 6/9/11, Berny Stapleton<berny@xxxxxxxxxxxxxxxxx>  wrote:
>> Can you tnsping the data source?
>>
>> On Thu, Jun 9, 2011 at 12:38 PM, David<dmauri@xxxxxxxxx>  wrote:
>>
>>>   Hi List,
>>>
>>> recently we have migrated to Xenapp6 into Hyper-v environment.
>>>
>>> We have installed Office 2010 32 bits edition because Microsoft
recommends
>>> 32 rather than 64b.
>>> Anyway, we also have ODBC oracle 10g release to access Oracle server, we
>>> use others programs to access and works fine.
>>>
>>> But, the problem is to access from Office (normally excel) to Oracle
using
>>> ODBC.
>>> I have tried many many thinks but I cannot fix the problem.
>>> ODBC administrator can only be configured from
>>> c:\windows\syswow64\odbcad32.exe
>>> Using this I can configure and test connection, and connection is
>>> succesfull.
>>>
>>> Moving to Excel and trying to access data from ODBC connection is not
>>> posible.
>>>
>>>
>>> Has anybody faced this problem?
>>>
>>> Thanks
>>>
>>>
> ************************************************
> For Archives, RSS, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> //www.freelists.org/list/thin
> ************************************************
>

************************************************
For Archives, RSS, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
//www.freelists.org/list/thin
************************************************

************************************************
For Archives, RSS, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
//www.freelists.org/list/thin
************************************************

Other related posts:

  1. Home
  2. thin
  3. Archive
  4. 06-2011