Oracle and HMG, can we fix it

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Oracle and HMG, can we fix it

Post by dragancesu »

Many times was the topic of Oracle and HMG, but it has not yet been resolved

What confuses me is that the program in harbour 3.0 works, there is only one library missing and it runs from the first, tested with oracle 10 xe
( \hb30\contrib\sddoci\tests\test1.prg), this is the best way to connect to the Oracle database

You will find the necessary library library
https://github.com/vrogier/ocilib/releases/ and download ocilib-4.3.3-windows.zip
in the folder \ lib32 \ ociliboci.a

An attempt to compile this example with hmg 3.4.4 gives errors I can not solve

Is there any will to try to solve it?

p.s. if necessary I can write a short instruction how to install (it's simple), make users and tables
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Oracle and HMG, can we fix it

Post by Rathinagiri »

Please give a working sample prg along with instructions.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: Oracle and HMG, can we fix it

Post by bpd2000 »

Dear dragancesu
What is the difference/advanage between Oracle and MySQL/ MariaDB etc.
BPD
Convert Dream into Reality through HMG
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: Oracle and HMG, can we fix it

Post by dragancesu »

Big, but it does not matter now

User data is an Oracle database, this is important
User avatar
serge_girard
Posts: 3161
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Oracle and HMG, can we fix it

Post by serge_girard »

I can not help, I have no Oracle experience at all!
Serge
There's nothing you can do that can't be done...
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: Oracle and HMG, can we fix it

Post by dragancesu »

First, download oracle 10 express edition (157 mb)

https://mega.nz/#!0HJzyKDQ!II4yduT1RgoN ... ZYfeRAdx7U

Don't worry, all oracle software is free for education and test

https://www.youtube.com/watch?v=CWCDDuJnJR0

After install create demo user and tables (demo user in oracle is SCOTT with password TIGER )

http://mycuteblog.com/oracle-10g-xe-cre ... lt-tables/
Last edited by dragancesu on Tue Oct 10, 2017 8:10 am, edited 1 time in total.
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Oracle and HMG, can we fix it

Post by mol »

My Company uses Oracle. I tried to connect with server and database, but without positive result.
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: Oracle and HMG, can we fix it

Post by bpd2000 »

System Properties Comparison of Microsoft SQL Server vs. MySQL vs. Oracle vs. SQLite
visit:
https://db-engines.com/en/system/Micros ... e%3BSQLite
BPD
Convert Dream into Reality through HMG
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: Oracle and HMG, can we fix it

Post by dragancesu »

Hello Mol, are your start with this instruction?

Actual version is 11XE but 10Xe have easy interface for beginers, no more download from oracle site and be upload to MEGA

*** instalation

Install is simple, start OracleXE.exe, just click on Next, only user enter is database_password (it's password for user SYSTEM)

After install go Oracle Database 10g Express Edition > Go To Database Home Page, connect with system/ database_password

Then Administration > Manage Database Users > Create

user. scott, password tiger (it's from oracle school) and exit

unpack demo.zip for demobld.sql (sql for create demo tables)

Then Oracle Database 10g Express Edition > Run SQL Command Line

on prompt type: connect scott/tiger

then type: start (yourfolder\)demobld.sql

type: select * from emp; ( if OK you can see 14 records ) and type exit or quit for exit

*** additional library

from https://github.com/vrogier/ocilib/releases/ download ocilib-4.3.3-windows.zip

*** for harbour 3.0

copy libocilib.a from (ocilib-4.3.3-windows.zip) \lib32\libocilib.a to \hb30\lib\win\mingw

program test1.prg on \hb30\contrib\sddoci\tests\test1.prg

make one update, line 19

Code: Select all

 ? "Connect:", tmp := RDDINFO( RDDI_CONNECT, { "OCILIB", "XE", "scott", "tiger" } )
note: XE is default SID for XE database, ORCL is default for standard edition

and hbmk2 test1.prg

it's work, next step is compile with hmg.3.4.4 and fix it
Attachments
DEMO.ZIP
(1.13 KiB) Downloaded 188 times
User avatar
apais
Posts: 440
Joined: Fri Aug 01, 2008 6:03 pm
DBs Used: DBF
Location: uruguay
Contact:

Re: Oracle and HMG, can we fix it

Post by apais »

Hello Dragan
I'm not Oracle user, but I'd like to know about Oracle express (free edition) limits (max tables, max records, stored prodecures etc).

TIA
Angel
Angel Pais
Web Apps consultant/architect/developer.
HW_apache (webserver modules) co-developer.
HbTron (Html GUI for harbour desktop hybrid apps) co-developer.
https://www.hbtron.com
Post Reply