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

Re: Oracle and HMG, can we fix it

Post by dragancesu »

All manufacturers have entry-level bases for test but are functional, Oracle and MS are called express edition

Full versions of the database use all of the resources they have (or are being paid) and the express are limited, oracle XE uses a one processor and 1 GB of memory, no matter how many servers it has, 10 XE is at least 4 GB of user data, at 11 XE 12 GB user data

For the rest there is no limit
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 »

Attachment contain program, source and executive version

When run you can see
picture1.jpg
picture1.jpg (77.51 KiB) Viewed 4546 times
picture2.jpg
picture2.jpg (140.92 KiB) Viewed 4546 times
Attachments
test1.zip
(820.73 KiB) Downloaded 178 times
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 »

So, you are saying that, it is running well in Harbour Console and not in HMG?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
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 »

That's right

Try to make a compilation with
build test1.prg
gives a result

Code: Select all

Harbour 3.2.0dev (r1703241902)
Copyright (c) 1999-2016, http://harbour-project.org/
C:/Users/dragan/AppData/Local/Temp/hbmk_h42adb.dir/test1.o:test1.c:(.data+0x1a8): undefined reference to `HB_FUN_SDDOCI'
collect2.exe: error: ld returned 1 exit status
hbmk2: Error: Running linker. 1
gcc.exe C:/Users/dragan/AppData/Local/Temp/hbmk_h42adb.dir/test1.o C:/Users/dragan/AppData/Local/Temp/hbmk_h42adb.dir/hbmk_znz58i.o c:/test/_temp.o    -pthread  -static-libgcc  -static-libstdc++  -static -lpthread -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbmysql -lmysql -lhbfimage -lhbpgsql -lsddmy -lhbvpdf -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lhbodbc -lodbc32 -lhbhpdf -lhbnetio -lxhb -lpng -llibhpdf -lhbzebra -lhbextern -lhbdebug -lhbvmmt -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib   -Wl,--end-group -otest1.exe  -LC:/hmg344/harbour/lib/win/mingw -LC:/hmg344/lib

hbmk2: Hint: Add option 'sddoci.hbc' for missing function(s): SDDOCI()
Shows that it is necessary to include sddoci.hbc , what really needs it?

Maybe I'm wrong, but how much do I see in HMG does not use .hbc, there are in some cases, but it's mostly zero content. I understand the function is inclusion of libraries and compiler options
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 »

If you make compile with HMG (it's possible), run and run-time error
image1.jpg
image1.jpg (27.58 KiB) Viewed 4497 times
In debuger you can see that function RDDINFO return wrong type argument
image2.jpg
image2.jpg (171.92 KiB) Viewed 4497 times
array instead of number
image3.jpg
image3.jpg (85.97 KiB) Viewed 4497 times
What is wrong here?
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 »

I've encountered the same problem trying to connect via sddodbc
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 »

I watched the harbor forum and I see that there are problems there

Now the current version is 3.2 and I installed it and tried the program

After launching messages is different
hb32a.jpg
hb32a.jpg (32.61 KiB) Viewed 4445 times
When copy requested file ociliba.dll
hb32b.jpg
hb32b.jpg (72.99 KiB) Viewed 4445 times
Works as in the previous version
hb32c.jpg
hb32c.jpg (68.92 KiB) Viewed 4445 times
hb32d.jpg
hb32d.jpg (134.34 KiB) Viewed 4445 times
Can someone say what's changed (because it looks for the library format) and how to fix it to work?
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 »

I see that the compilation should say what to connect
at the harbor 3,2, this is in two .hbc file, content is

sddoci.hbc

Code: Select all

description=RDDSQL OCILib (Oracle SQL) backend

libs=${_HB_DYNPREF}${hb_name}${_HB_DYNSUFF}
{HB_WITH_OCILIB_WIDE}libs=ocilibw
{HB_WITH_OCILIB_MIXED}libs=ocilibm
{!HB_WITH_OCILIB_WIDE&!HB_WITH_OCILIB_MIXED&linux}libs=ocilib
{!HB_WITH_OCILIB_WIDE&!HB_WITH_OCILIB_MIXED&!linux}libs=ociliba

libs=rddsql.hbc 
rddsql.hbc

Code: Select all

description=RDDSQL core RDD

incpaths=.

headers=hbrddsql.ch

libs=${_HB_DYNPREF}${hb_name}${_HB_DYNSUFF} 
Can anyone write what this is saying to a compiler ? And how this write when compile in hmg ?
User avatar
srvet_claudio
Posts: 2193
Joined: Thu Feb 25, 2010 8:43 pm
Location: Uruguay
Contact:

Re: Oracle and HMG, can we fix it

Post by srvet_claudio »

Insert in you .hbp file:

YouTest.prg
sddoci.hbc
rddsql.hbc

See:
http://harbourlanguage.blogspot.com/201 ... 2.html?m=1
Best regards.
Dr. Claudio Soto
(from Uruguay)
http://srvet.blogspot.com
Post Reply