O$5.1 Cannot LogOn to Oracle with W7 64b solved!

[Roberto Targa]

Hi Alain, Jean Marc and Marten,
thanks to Omnis support I solved the Oracle logon problem.
With Studio 5.1 on windows 7 64 bis you MUST use Oracle Instant Client 11.2 32 bit. I was using Oracle 10g XE client that worked with 4.3.1 and w7 32 bit, but not with 5.1on 64 bit.
Anybody was aware of this? 
The advantage of Instant Client is that you do not have to install it, simply put the folder where you like and reference it in the environment variable PATH, say C:\InstanClient_11_2

HTH

Roberto Targa

Il giorno 08/dic/2010, alle ore 21.48, Alain Stouder ha scritto:

> Hi Roberto,
> 
> I found this, read at the end of the page, there seems to be an issue with oracle client prior to version 11 on Windows 
> and a difference of data format between 32 bit and 64 bit client:
> http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7ac3082d-154c-45cb-8bf0-ab12018d8fda/
> 
> HTH,
> Alain
> 
> On 8 déc. 2010, at 18:48, Roberto Targa wrote:
> 
>> Hi Jean Mark, Alain and Marten.
>> My W7 machine has omnis studio 5.1 development installed in c:\programs (x86) and the db is oracle 10g XE installed on the same machine.
>> I have no problem in connecting to this db from Studio 4.3.1development, but no way to connect from studio 5.1.
>> 
>> It doesn't matter the Oracle db  version, since I have the same problem with Oracle 11g server installed on a different machine.
>> i suspect the problem is with Omnis Oracle DAM.
>> Anybody with a similar setup can connect to oracle 10g/11g with Studio 5.1?
>> 
>> TIA
>> Roberto Targa
>> 
>> 
>> Il giorno 08/dic/2010, alle ore 08.36, Jean Marc Azerad ha scritto:
>> 
>>> Roberto,
>>> 
>>> With Studio 5, the Oracle Client should be at list version 9 (cn be 10 or 11) even if the database is Version 8, is this the case ?
>>> 
>>> JM
>>> 
>>> Le 7 déc. 2010 à 18:30, Roberto Targa a écrit :
>>> 
>>>> Hi Jean Marc,
>>>> thank for your answer.
>>>> I'm using the 32 bit Oracle client on the W7 64 bit, but it doesn't connect. The Oracle XE db encoding is not unicode but MSWIN1251. Does'it matter?
>>>> 
>>>> Il giorno 05/dic/2010, alle ore 09.32, Jean Marc Azerad ha scritto:
>>>> 
>>>>> Roberto,
>>>>> Use the 32 bit Oracle Client, even on W7  64
>>>>> 
>>>>> Ciao
>>>>> 
>>>>> JM
>>>>> 
>>>>> Le 4 déc. 2010 à 17:56, Roberto Targa a écrit :
>>>>> 
>>>>>> Hi All,
>>>>>> I cannot login to Oracle using ORA8 DAM with Studio 5.1 on  W7 64bit . 
>>>>>> No problem with the same machine using Studio 4.3.1non unicode.
>>>>>> Is there anybody who could connect Studio 5.1 to Oracle on a W7 64 bit.?
>>>>>> 
>>>>>> TIA
>>>>>> 
>>>>>> Roberto Targa
>>>>>> 
>>>>>> _____________________________________________________________
>>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>> 
>>>>> _____________________________________________________________
>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>> 
>>>> 
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com