Oracle db ??

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
link76
Posts: 99
Joined: Fri Nov 04, 2011 1:52 pm

Oracle db ??

Post by link76 » Thu Feb 27, 2014 11:34 am

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
Posts: 13806
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Oracle db ??

Post by Klaus » 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

link76
Posts: 99
Joined: Fri Nov 04, 2011 1:52 pm

Re: Oracle db ??

Post by link76 » Thu Feb 27, 2014 12:52 pm

I have the Commercial Edition!

Klaus
Posts: 13806
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Oracle db ??

Post by Klaus » Thu Feb 27, 2014 12:55 pm

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

bangkok
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 937
Joined: Fri Aug 15, 2008 7:15 am

Re: Oracle db ??

Post by bangkok » 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.

Post Reply

Return to “Getting Started with LiveCode - Complete Beginners”