Oracle and HMG, can we fix it
Moderator: Rathinagiri
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Oracle and HMG, can we fix it
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
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
- 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
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.
South or North HMG is worth.
...the possibilities are endless.
Re: Oracle and HMG, can we fix it
Dear dragancesu
What is the difference/advanage between Oracle and MySQL/ MariaDB etc.
What is the difference/advanage between Oracle and MySQL/ MariaDB etc.
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: Oracle and HMG, can we fix it
Big, but it does not matter now
User data is an Oracle database, this is important
User data is an Oracle database, this is important
- serge_girard
- Posts: 3169
- 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
I can not help, I have no Oracle experience at all!
Serge
Serge
There's nothing you can do that can't be done...
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: Oracle and HMG, can we fix it
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/
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.
Re: Oracle and HMG, can we fix it
My Company uses Oracle. I tried to connect with server and database, but without positive result.
Re: Oracle and HMG, can we fix it
System Properties Comparison of Microsoft SQL Server vs. MySQL vs. Oracle vs. SQLite
visit:
https://db-engines.com/en/system/Micros ... e%3BSQLite
visit:
https://db-engines.com/en/system/Micros ... e%3BSQLite
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: Oracle and HMG, can we fix it
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
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
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" } )
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 189 times
Re: Oracle and HMG, can we fix it
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
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.
Web Apps consultant/architect/developer.