O73 v7.1 with windows8 and oracle

[Alain Stouder OmnisNews]

Check other config files that the Omnis DAM can read?

---
Learn something new everyday!

On 21 août 2013, at 11:07, A Blanchard <infomni at yahoo.fr> wrote:

> Hello Alain
> 
> My tnsnames.ora is a copy of my windows 7 pc and it is in ansi.
> 
> Thanks
> 
> 
> ________________________________
> De : Alain Stouder <omnis at smartway.ch>
> À : A Blanchard <infomni at yahoo.fr>; OmnisDev List - English <omnisdev-en at lists.omnis-dev.com> 
> Envoyé le : Mercredi 21 août 2013 10h20
> Objet : Re: O73 v7.1 with windows8 and oracle
> 
> 
> Check if tnsnames.ora is in unicode, if so resave it in ansi.
> 
> If I remember well, we had this issue with newer Oracle client ware that is unicode based and Omnis 7383-Studio4321 ANSI clients.
> 
> On Aug 21, 2013, at 10:14 AM, A Blanchard <infomni at yahoo.fr> wrote:
> 
>> Hello Jim
>> 
>> Thanks for the advice.
>> 
>> I also tried with o73v8.3 and the problem is the same.
>> 
>> All ideas are welcome.
>> 
>> Thanks
>> 
>> De : Jim Creak <jim at jacsoft.co.nz>
>> À : A Blanchard <infomni at yahoo.fr>; OmnisDev List - English <omnisdev-en at lists.omnis-dev.com> 
>> Envoyé le : Mercredi 21 août 2013 0h14
>> Objet : Re: O73 v7.1 with windows8 and oracle
>> 
>> 
>> No idea about connecting to oracle8, but you should update to o73v8.3 I believe the runtime numbers are the same.  I think you can download this version from the Tiger Logic FTP server.
>> 
>> Thanks
>> Jim
>> 
>> JACSoft Programming Ltd.
>> 
>> 
>> 
>> On 20/08/2013, at 11:07 PM, A Blanchard wrote:
>> 
>>> Hello everybody
>>> 
>>> I need to install omnis7.3 v7.1 on a windows8 pc to connect to oracle8
>>> 
>>> 1) Omnis
>>> I copied the entire directory from a windows 7 installation and I can run omnis
>>> But when I tried Start session 'ORACLE' with the logon manager of 07sshel.lbr, I get an error
>>> "The SQL Shell was unable to log on because it could not find the necessary Data Access Module ORACLE"
>>> 
>>> However the oracle.dll is in the external directory
>>> 
>>> Is there a new version of oracle.dll ?
>>> 
>>> The dropdown list doesn't work
>>> 
>>> Is there a patch for 07.3.7.1 ?
>>> 
>>> 
>>> 2) Oracle
>>> I  followed the indications in
>>> http://matthieucornillon.fr/2011/07/installer-le-client-oracle-sous-windows/
>>> 
>>> I  downloaded Instant Client fom oracle:
>>> - instantclient-basic-win64-10.2.0.5
>>> - instantclient-sqlplus-win64-10.2.0.5
>>> 
>>> I can connect to my database with sqlplus  user/pass at ip:1521/orcl
>>> But when I want to use a tnsnames.ora (after create it in my instantclient directory and update my PATH and TNS_ADMIN environnement variables), the connection failed.
>>> 
>>> Is someone try this configuration ?
>>> 
>>> Thanks for your help
>>> 
>>> Arnaud Blanchard
>>> _____________________________________________________________
>>> 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
>