Oracle db ??

[link76]

how to connect to oracle database ?

values:

Code: Select all

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

[Klaus]

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

[link76]

I have the Commercial Edition!

[Klaus]

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

[bangkok]

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.