Page 1 of 2
Connection string
Posted: Fri Sep 02, 2016 4:50 pm
by D4vidrim
Hello!
I need to connect to an Oracle DB.
Here's the connection string I've received from the IT guys:
REC_PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xyz.abc.asd.poi)(PORT = 1521))
)
(CONNECT_DATA = (SID = REC))
)
If I try to connect with SQL Developer I use:
Host: xyz.abc.asd.poi
Port: 1521
SID: REC
then I put my userid and password and it works.
On Livecode, in order to check the connection I use this script:
put revOpenDatabase( tDBType, tHost,tNome, tUser, tPwd ) into theConnectionID
answer "Id connessione: " &theConnectionID
where tDBType='oracle'
tHost='xyz.abc.asd.poi:1521'
tNome='REC'
Unfortunately it doesn't work, I don't get any error, LiveCode just quit on Windows XP while processing the first command with put revOpenDatabase.
I've checked every single variable and they all have the right string inside, what's wrong with it? Should I use a different string?
Please help me!
Re: Connection string
Posted: Wed Sep 07, 2016 5:46 am
by D4vidrim
Anyone has any tip to give?
Re: Connection string
Posted: Wed Sep 07, 2016 1:38 pm
by MaxV
Oracle DB driver are only in livecode commercial version.
Do you use it?
Did you read this:
http://livecode.wikia.com/wiki/OracleDB ?
Re: Connection string
Posted: Tue Oct 04, 2016 8:32 pm
by D4vidrim
Right now I'm using the Indy Version.
Re: Connection string
Posted: Wed Oct 05, 2016 2:13 pm
by Klaus
MaxV wrote:Oracle DB driver are only in livecode commercial version.
D4vidrim wrote:Right now I'm using the Indy Version.
OK, that should give you a clue!
Re: Connection string
Posted: Wed Oct 05, 2016 7:50 pm
by D4vidrim
Indy an Business are both commercial version of livecode, aren't they?
I haven't found any differences about Oracle DB on those 2 licences. Maybe I haven't looked on the right place?
Anyway I'm buying the Business versione in a month or so, then I hope this problem will disappear!
Re: Connection string
Posted: Wed Oct 05, 2016 7:59 pm
by Klaus
D4vidrim wrote:Indy an Business are both commercial version of livecode, aren't they?
True, but Max means the "Business" edtion of Livecode.
The INDY version does not support connection to a ORACLE database.
Re: Connection string
Posted: Thu Oct 06, 2016 7:31 am
by MaxV
Klaus wrote:D4vidrim wrote:Indy an Business are both commercial version of livecode, aren't they?
True, but Max means the "Business" edtion of Livecode.
The INDY version does not support connection to a ORACLE database.
Really? Are you sure?
The only differences between indy and business should be the annual revenues. If you earn more than $ 500,000 , you have to buy the business.
On this page there is no mention of driver difference between indy and business (
https://livecode.com/products/livecode- ... m/pricing/ ).
All business features are just:
- PDF viewev
- mergExt
- for teams
- better support from livecode
If oracle db driver are not included in INDY, livecode should declare it on plans page.
Re: Connection string
Posted: Thu Oct 06, 2016 10:22 am
by Klaus
Hi Max,
MaxV wrote:Klaus wrote:...
The INDY version does not support connection to a ORACLE database.
Really? Are you sure?
No!
At least this limitation has been present in earlier versions.
However if I look into the "Database Driver" folder inside of the LC app package,
there is no ORACLE database driver present in my INDY version!
Best
Klaus
Re: Connection string
Posted: Thu Oct 06, 2016 11:37 am
by dave.kilroy
Hi all
Klaus I've got an Indie copy of LiveCode and appear to have access to Oracle (although not for all platforms)
Klaus wrote:Hi Max,
MaxV wrote:Klaus wrote:...
The INDY version does not support connection to a ORACLE database.
Really? Are you sure?
No!
At least this limitation has been present in earlier versions.
However if I look into the "Database Driver" folder inside of the LC app package,
there is no ORACLE database driver present in my INDY version!
Best
Klaus
Re: Connection string
Posted: Thu Oct 06, 2016 12:13 pm
by Klaus
Hi Dave,
yes, I can also check ORACLE in the "Inclusions" tab of the standalone builder setting,
but I made a little standalone with ORACLE checked there and this is what I got, see screenshot.
Not very surprised to be honest.
And yes, Livecode should make this clear somehow!
Best
Klaus
Re: Connection string
Posted: Thu Oct 06, 2016 12:20 pm
by dave.kilroy
Klaus - gosh just checked - you're completely right and I was fooled by the GUI!
Klaus wrote:Hi Dave,
yes, I can also check ORACLE in the "Inclusions" tab of the standalone builder setting,
but I made a little standalone with ORACLE checked there and this is what I got, see screenshot.
Not very surprised to be honest.
And yes, Livecode should make this clear somehow!
Best
Klaus
Re: Connection string
Posted: Fri Oct 07, 2016 7:49 am
by D4vidrim
By the way, on this website
http://livecode.wikia.com/wiki/OracleDB
They write:
Code: Select all
put revOpenDatabase("oracle",databaseName, DBHOST_Oracle, DBUSER_Oracle,DBPSWD_Oracle) into gConnectionID_Oracle
But then the example is:
Code: Select all
put revOpenDatabase("oracle", "www.example.com", "MyDB", myUsr, myPass) into cID
As you can see, they switch DBName with the DBHost... same thing on other documentation found on the web.
Re: Connection string
Posted: Fri Oct 07, 2016 10:11 am
by MaxV
D4vidrim wrote:By the way, on this website
http://livecode.wikia.com/wiki/OracleDB
They write:
Code: Select all
put revOpenDatabase("oracle",databaseName, DBHOST_Oracle, DBUSER_Oracle,DBPSWD_Oracle) into gConnectionID_Oracle
But then the example is:
Code: Select all
put revOpenDatabase("oracle", "www.example.com", "MyDB", myUsr, myPass) into cID
As you can see, they switch DBName with the DBHost... same thing on other documentation found on the web.
What is the correct syntax?
I suppose
Code: Select all
put revOpenDatabase("oracle", "www.example.com", "MyDB", myUsr, myPass) into cID
Please let me know.
Re: Connection string
Posted: Tue Oct 11, 2016 8:45 am
by MaxV