LiveCode Forums.

Posted: **Thu Feb 27, 2014 11:34 am**

how to connect to oracle database ?

values:

DW= 
  (DESCRIPTION= 
    (ADDRESS= 
      (PROTOCOL=TCP) 
      (HOST=10.30.1.11) 
      (PORT=1521) 
    ) 
    (CONNECT_DATA= 
      (SID=TSH1) 
    ) 
  )

livecode:

Code: Select all

   put "10.30.1.11:1521" into DBHOST_Oracle
   put "TSH1" into databaseName
   put "myuser" into DBUSER_Oracle
   put "mypwd" into DBPSWD_Oracle
   
   put revOpenDatabase("oracle",databaseName, DBHOST_Oracle, DBUSER_Oracle,DBPSWD_Oracle) into gConnectionID_Oracle

I receive a "revdberr, invalid database type" error

thank you

Posted: **Thu Feb 27, 2014 12:44 pm**

Hi link76,

as far as I remember, you can only connect to an ORACLE database
with the commercial edition of Livecode, NOT the Community edition.

Are you using the community version?

Best

Klaus

Posted: **Thu Feb 27, 2014 12:52 pm**

I have the Commercial Edition!

Posted: **Thu Feb 27, 2014 12:55 pm**

Oh, then it should work!?
Sorry, no other idea.

Posted: **Thu Feb 27, 2014 2:06 pm**

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

Look at the dictionnary :
revOpenDatabase("oracle",host[:port], databaseName, [userName],[password])

you have inverted host and databasename.

LiveCode Forums.

Oracle db ??

Oracle db ??

Re: Oracle db ??

Re: Oracle db ??

Re: Oracle db ??

Re: Oracle db ??