[LiveCode community 6.5]Connect to Oracle Database

[sadajana]

Hi everyone,

I'm trying to connect to an Oracle database backend with LIVECODE COMMUNITY 6.5 and each time I'm encoutering this error :
Invalid database type
my questions :
1. is Oracle database accessible via LiveCode Community 6.5 ?
2. is this related to the connection string I'm providing to call the connectionhandler ?
code :

Code: Select all

   put revOpenDatabase("oracle", tDatabaseAdress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult

please suggest how to proceed on this.

Regards,
Sada

[Mark]

Hi Sada,

Earlier, I wrote here that Orcale isn't supported, but that's wrong. Oracle is in the list of supported database types.

It looks like the documentation got the syntax for Oracle databases wrong. Try this:

Code: Select all

 put revOpenDatabase("oracle",tDatabaseName,tDatabaseAdress,tDatabaseUser,tDatabasePassword) into tResult

It seems that tDatabaseName and tDatabaseAdress should be switched. Also, are you sure that there is no spelling error in tDatabaseAdress? If you type it with one "d" in the function but with two "d's" elsewhere in your script, it won't work.

Kind regards,

Mark

[sadajana]

Hi Mark,

Thanks for the reply, after switching the parameters, the error message has changed :

it says : button "Connect": execution error at line 12(Function: error in function handler) near "revOpenDatabase", char 8

Also, to be sure if I'm not misspelling the parameter names, I've replaced the parameters with the actual values but the error is still there
overall, I think the error description in LIVECODE is very poor and not enough explanatory.

Regards,
Sada

[LCNeil]

Hi sadajana et al.

There is no oracle support for LiveCode Community due to conflicts with the GPL licences that is used. If you wish to connect directly to a Oracle database, you will need to use the commercial version of LiveCode

Kind Regards,


Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
--

[Mark]

Thanks Neil, that's good to know. Has this been documented somewhere?

Mark

[LCNeil]

Hi Mark,

I've put in a request with our QC team to have this added to our documentation.

Kind Regards,


Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
--