Have we lost the Oracle driver?

[panagiotis m]

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
>