Have we lost the Oracle driver?

Ben Rubinstein benr_mc at cogapp.com
Tue Mar 1 10:51:27 EST 2022


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?

Panos can you comment?

Many thanks,

Ben

On 01/03/2022 15:33, matthias rebbe via use-livecode wrote:
> I just had a quick look at the LC externals/database  and the runtime/externals/database folders. There are still dboracle... files in it.
> So at least the drivers are there.
> 
> 
> Matthias
> 
> 
>> Am 01.03.2022 um 16:24 schrieb Ben Rubinstein via use-livecode <use-livecode at lists.runrev.com>:
>>
>> A long time ago I used to access Oracle directly from a LiveCode app.
>>
>> For some years now I've only done this via ODBC, though I don't recall why that changed.
>>
>> The Dictionary entry for revOpenDatabase lists five variants ("mysql", "odbc",  "sqlite", "postgresql", "oracle"); but the User Guide (p. 303) lists three plus ODBC.
>>
>> Now I'm trying to access an Oracle database directly again (in the IDE), and when my code hits
>> 	revOpenData("oracle", ....)
>>
>> it breaks into the debugger as if there was a breakpoint on that statement - there isn't; it switches to but the "Errors" tab says "No errors found".
>>
>> However after 'stepping', it halts altogether and the errors tab says
>>
>> 	execution error at line n/a (External handler execution error: revdberr,driver not licensed for this edition)
>>
>> As I understand it there is now only one edition (with a buffet of deployment platforms), the Standard Plan, and my account says that I have a "LiveCode Professional" license (I admit that I am thoroughly confused about plans, licenses etc). Oracle isn't mentioned in the "Pro Feature Pack" either.
>>
>> Is Oracle supported? If so what do I need to do to access that?
>>
>> TIA,
>>
>> Ben
>>
>> _______________________________________________
>> 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