Have we lost the Oracle driver?

Ben Rubinstein benr_mc at cogapp.com
Thu Mar 3 08:23:39 EST 2022


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



More information about the use-livecode mailing list