Have we lost the Oracle driver?

[panagiotis m]

Hello Ben,

I _think_ you just have to create a symlink to this version of the
libclntsh:

1. Open a Terminal
2. Navigate to the instant client directory, e.g. suppose it is in your
Downloads:

cd ~/Downloads/instantclient_11_2

3. Create the symlink:

ln -s libclntsh.dylib.11.1 libclntsh.dylib

Kind regards,
Panos
--

On Thu, 3 Mar 2022 at 15:25, Ben Rubinstein via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Hi Panos,
>
> LiveCode 9.6.6 on macOS 10.15.7 (Catalina).
>
> I've downloaded the Oracle stuff but it doesn't seem to have an install
> script
> - where should I put "libclntsh.dylib.11.1"?
>
> thanks for your help,
>
> Ben
>
> On 02/03/2022 12:58, panagiotis m via use-livecode wrote:
> > Hello Ben,
> >
> > I take it you are on MacOS? Which MacOS version, and which LiveCode
> version
> > are you using?
> >
> > Could it be the case you haven't got the right version of Oracle Instant
> > Client installed? You need libclntsh.dylib.11.1, found here:
> >
> >
> https://download.oracle.com/otn/mac/instantclient/11204/instantclient-basic-macos.x64-11.2.0.4.0.zip
> >
> > Kind regards,
> > Panos
> > --
> >
> > On Tue, 1 Mar 2022 at 19:46, Ben Rubinstein via use-livecode <
> > use-livecode at lists.runrev.com> wrote:
> >
> >> Hi Mark,
> >>
> >> Thanks for responding. Indeed 'the revLicenseInfo` returned
> >> "...commercial".
> >> After re-licensing, it now says "...professional" - however, I still
> can't
> >> open a connection to an Oracle database.
> >>
> >> Re-licensing *did* make a difference: whereas previously it broke into
> the
> >> debugger, and (sometimes) displayed the error
> >>   > execution error at line n/a (External handler execution error:
> >> revdberr,driver not licensed for this edition)
> >>
> >> now revOpenDatabase simply returns
> >>   > revdberr,invalid database type
> >>
> >> So I guess it's not a licensing issue any more, which is good; but I
> still
> >> can't get at the database! Can you suggest where my next issue might be?
> >>
> >> Many thanks,
> >>
> >> Ben
> >>
> >> On 01/03/2022 16:08, Mark Waddingham via use-livecode wrote:
> >>> On 2022-03-01 15:51, Ben Rubinstein via use-livecode wrote:
> >>>> Hi Matthias,
> >>>>
> >>>> Good spot! Thanks for checking.
> >>>>
> >>>> I wonder whether this is an accidental omission, in that Oracle was at
> >>>> one time only available at a certain higher level of license; maybe
> >>>> now that there is only level, perhaps someone forgot to tweak whatever
> >>>> bit of code checked that the 'correct' license was in place?
> >>>
> >>> All business-only features were moved to be part of the pro features
> >> pack -
> >>> the oracle driver included.
> >>>
> >>> If it isn't working in your current version of LC, check that the
> >> license you
> >>> have licensed LC with does have the pro features pack in it...
> >>>
> >>> If you do `put the revLicenseInfo` it should say professional, rather
> >> than
> >>> commercial.
> >>>
> >>> If it doesn't say professional, Relicense your IDE using the menu item
> >> in Help
> >>> and flick through the licenses you have available until one says 'pro'
> >> in the
> >>> title.
> >>>
> >>> If the revLicenseInfo does say professional then something odd has
> >> happened
> >>> somewhere which will need to look into more deeply!
> >>>
> >>> Warmest Regards,
> >>>
> >>> Mark.
> >>>
> >>
> >> _______________________________________________
> >> use-livecode mailing list
> >> use-livecode at lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>