Oracle and HMG, can we fix it

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
dragancesu
Posts: 476
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 73 times

Oracle and HMG, can we fix it

Post by dragancesu » Sun Oct 08, 2017 9:36 pm

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: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 141 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Mon Oct 09, 2017 3:54 am

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: 962
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 132 times
Been thanked: 43 times

Post by bpd2000 » Mon Oct 09, 2017 4:23 am

Dear dragancesu
What is the difference/advanage between Oracle and MySQL/ MariaDB etc.
BPD
Convert Dream into Reality through HMG

User avatar
dragancesu
Posts: 476
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 73 times

Post by dragancesu » Mon Oct 09, 2017 11:03 am

Big, but it does not matter now

User data is an Oracle database, this is important

User avatar
serge_girard
Posts: 1904
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 314 times
Been thanked: 74 times
Contact:

Post by serge_girard » Mon Oct 09, 2017 2:52 pm

I can not help, I have no Oracle experience at all!
Serge

User avatar
dragancesu
Posts: 476
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 73 times

Post by dragancesu » Mon Oct 09, 2017 8:01 pm

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: 2874
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 133 times
Been thanked: 66 times
Contact:

Post by mol » Mon Oct 09, 2017 8:39 pm

My Company uses Oracle. I tried to connect with server and database, but without positive result.

User avatar
bpd2000
Posts: 962
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 132 times
Been thanked: 43 times

Post by bpd2000 » Tue Oct 10, 2017 4:01 am

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: 476
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 73 times

Post by dragancesu » Tue Oct 10, 2017 8:47 am

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 15 times

User avatar
apais
Posts: 260
Joined: Fri Aug 01, 2008 6:03 pm
Location: uruguay
Has thanked: 23 times
Been thanked: 15 times
Contact:

Post by apais » Tue Oct 10, 2017 3:51 pm

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

Post Reply