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@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@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@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@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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
