Oracle and HMG, can we fix it

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

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

Re: Oracle and HMG, can we fix it

Post by dragancesu » Tue Oct 10, 2017 4:16 pm

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

Post by dragancesu » Tue Oct 10, 2017 4:19 pm

Attachment contain program, source and executive version

When run you can see
picture1.jpg
picture1.jpg (77.51 KiB) Viewed 216 times
picture2.jpg
picture2.jpg (140.92 KiB) Viewed 216 times
Attachments
test1.zip
(820.73 KiB) Downloaded 10 times

User avatar
Rathinagiri
Posts: 5166
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 129 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Tue Oct 10, 2017 5:44 pm

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

Post by dragancesu » Tue Oct 10, 2017 8:37 pm

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

Post by dragancesu » Thu Oct 12, 2017 3:48 pm

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

User avatar
mol
Posts: 2842
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 119 times
Been thanked: 65 times
Contact:

Post by mol » Thu Oct 12, 2017 5:52 pm

I've encountered the same problem trying to connect via sddodbc

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

Post by dragancesu » Mon Oct 16, 2017 7:09 pm

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 115 times
When copy requested file ociliba.dll
hb32b.jpg
hb32b.jpg (72.99 KiB) Viewed 115 times
Works as in the previous version
hb32c.jpg
hb32c.jpg (68.92 KiB) Viewed 115 times
hb32d.jpg
hb32d.jpg (134.34 KiB) Viewed 115 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: 457
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 67 times

Post by dragancesu » Fri Oct 20, 2017 7:51 am

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: 1948
Joined: Thu Feb 25, 2010 8:43 pm
Location: Uruguay
Has thanked: 30 times
Been thanked: 119 times
Contact:

Post by srvet_claudio » Fri Oct 20, 2017 2:08 pm

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