Connection string
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Connection string
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!
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
Anyone has any tip to give?
Re: Connection string
Oracle DB driver are only in livecode commercial version.
Do you use it?
Did you read this: http://livecode.wikia.com/wiki/OracleDB ?
Do you use it?
Did you read this: http://livecode.wikia.com/wiki/OracleDB ?
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
Re: Connection string
Right now I'm using the Indy Version.
Re: Connection string
MaxV wrote:Oracle DB driver are only in livecode commercial version.
OK, that should give you a clue!D4vidrim wrote:Right now I'm using the Indy Version.
Re: Connection string
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!
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
True, but Max means the "Business" edtion of Livecode.D4vidrim wrote:Indy an Business are both commercial version of livecode, aren't they?
The INDY version does not support connection to a ORACLE database.
Re: Connection string
Really? Are you sure?Klaus wrote:True, but Max means the "Business" edtion of Livecode.D4vidrim wrote:Indy an Business are both commercial version of livecode, aren't they?
The INDY version does not support connection to a ORACLE database.
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.
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
Re: Connection string
Hi Max,
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
No!MaxV wrote:Really? Are you sure?Klaus wrote:...
The INDY version does not support connection to a ORACLE database.
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
-
- VIP Livecode Opensource Backer
- Posts: 858
- Joined: Wed Jun 24, 2009 1:17 pm
- Location: Plymouth, UK
- Contact:
Re: Connection string
Hi all
Klaus I've got an Indie copy of LiveCode and appear to have access to Oracle (although not for all platforms)
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,No!MaxV wrote:Really? Are you sure?Klaus wrote:...
The INDY version does not support connection to a ORACLE database.
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
"...this is not the code you are looking for..."
Re: Connection string
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
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
-
- VIP Livecode Opensource Backer
- Posts: 858
- Joined: Wed Jun 24, 2009 1:17 pm
- Location: Plymouth, UK
- Contact:
Re: Connection string
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
"...this is not the code you are looking for..."
Re: Connection string
By the way, on this website http://livecode.wikia.com/wiki/OracleDB
They write:
But then the example is:
As you can see, they switch DBName with the DBHost... same thing on other documentation found on the web.
They write:
Code: Select all
put revOpenDatabase("oracle",databaseName, DBHOST_Oracle, DBUSER_Oracle,DBPSWD_Oracle) into gConnectionID_Oracle
Code: Select all
put revOpenDatabase("oracle", "www.example.com", "MyDB", myUsr, myPass) into cID
Re: Connection string
What is the correct syntax?D4vidrim wrote:By the way, on this website http://livecode.wikia.com/wiki/OracleDB
They write:
But then the example is:Code: Select all
put revOpenDatabase("oracle",databaseName, DBHOST_Oracle, DBUSER_Oracle,DBPSWD_Oracle) into gConnectionID_Oracle
As you can see, they switch DBName with the DBHost... same thing on other documentation found on the web.Code: Select all
put revOpenDatabase("oracle", "www.example.com", "MyDB", myUsr, myPass) into cID
I suppose
Code: Select all
put revOpenDatabase("oracle", "www.example.com", "MyDB", myUsr, myPass) into cID
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
Re: Connection string
Bug reported: http://quality.livecode.com/show_bug.cgi?id=18583
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w