FANDOM


Please note of this bug: http://quality.livecode.com/show_bug.cgi?id=18583

In order to connect to a OracleDB, you need a commercial (business) version of livecode, because the oracle drivers are proprietary. The connection is:

put revOpenDatabase("oracle", DBHOST_Oracle, databaseName, DBUSER_Oracle,DBPSWD_Oracle) into gConnectionID_Oracle

where:

  • Databasename is the name of the database
  • DBHOST_Oracle is the internet/local address of the database, you may specify also a port
  • BUSER_Oracle is the user name
  • DBPSWD_Oracle is the user password

Example:

put revOpenDatabase("oracle", "www.example.com", "MyDB", myUsr, myPass) into cID