Have we lost the Oracle driver?

[Ben Rubinstein]

I'm attempting to re-up this.

I've been distracted by other issues, but now trying again to use the direct 
Oracle driver, rather than the ODBC one.

I have confirmed that LiveCode is appropriately licensed ("professional" 
rather than "commercial"); and the standalone package contains 
"dboracle.bundle"(on Mac); on Windows the "dboracle.dll" is in the Externals 
folder.

The current situation is that when I attempt this on Mac, I get the error message:

	'revdberr,invalid database type' (30)


On Windows, the standalone crashes.

Where next...?

TIA,

Ben

On 03/03/2022 17:14, Ben Rubinstein via use-livecode wrote:
> Hi Panos,
> 
> Alas, that's made no difference.
> 
> Does this error message "revdberr,invalid database type" actually indicate a 
> failure to load the driver, or can it also occur if the driver was loaded but 
> there were issues initialising it, or some other issues connecting to the 
> given server and database?
> 
> Is there any other detail of errors available anywhere (I looked at the 
> Console but there is just a continual tide of reports in that, so I couldn't 
> spot anything)?
> 
> Thanks again,
> 
> Ben
> 
> On 03/03/2022 16:23, panagiotis m via use-livecode wrote:
>> 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
>>>
>> _______________________________________________
>> 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