Re: Have we lost the Oracle driver?
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
Re: Have we lost the Oracle driver?
LC with licensed pro features has native Oracle support. So Oracle should be the correct keyword. And as Ben already stated he has pro feature licenesed and want to use the built in Oracle drivers. > Am 03.03.2022 um 23:45 schrieb Bob Sneidar via use-livecode > : > > ODBC is the driver type. Are you trying to use Oracle as the driver type? > > Bob S > > >> On Mar 3, 2022, at 09: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 > > > ___ > 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
Re: Have we lost the Oracle driver?
ODBC is the driver type. Are you trying to use Oracle as the driver type? Bob S > On Mar 3, 2022, at 09: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 ___ 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
Re: Have we lost the Oracle driver?
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
Re: Have we lost the Oracle driver?
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
Re: Have we lost the Oracle driver?
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
Re: Have we lost the Oracle driver?
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
Re: Have we lost the Oracle driver?
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
Re: Have we lost the Oracle driver?
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. -- Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/ LiveCode: Everyone can create apps ___ 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
Re: Have we lost the Oracle driver?
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
:
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@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
Re: Have we lost the Oracle driver?
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
> :
>
> 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@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
