Page 2 of 2

Re: Oracle and HMG, can we fix it

Posted: Tue Oct 10, 2017 4:16 pm
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

Re: Oracle and HMG, can we fix it

Posted: Tue Oct 10, 2017 4:19 pm
by dragancesu
Attachment contain program, source and executive version

When run you can see
picture1.jpg
picture1.jpg (77.51 KiB) Viewed 4584 times
picture2.jpg
picture2.jpg (140.92 KiB) Viewed 4584 times

Re: Oracle and HMG, can we fix it

Posted: Tue Oct 10, 2017 5:44 pm
by Rathinagiri
So, you are saying that, it is running well in Harbour Console and not in HMG?

Re: Oracle and HMG, can we fix it

Posted: Tue Oct 10, 2017 8:37 pm
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

Re: Oracle and HMG, can we fix it

Posted: Thu Oct 12, 2017 3:48 pm
by dragancesu
If you make compile with HMG (it's possible), run and run-time error
image1.jpg
image1.jpg (27.58 KiB) Viewed 4535 times
In debuger you can see that function RDDINFO return wrong type argument
image2.jpg
image2.jpg (171.92 KiB) Viewed 4535 times
array instead of number
image3.jpg
image3.jpg (85.97 KiB) Viewed 4535 times
What is wrong here?

Re: Oracle and HMG, can we fix it

Posted: Thu Oct 12, 2017 5:52 pm
by mol
I've encountered the same problem trying to connect via sddodbc

Re: Oracle and HMG, can we fix it

Posted: Mon Oct 16, 2017 7:09 pm
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 4483 times
When copy requested file ociliba.dll
hb32b.jpg
hb32b.jpg (72.99 KiB) Viewed 4483 times
Works as in the previous version
hb32c.jpg
hb32c.jpg (68.92 KiB) Viewed 4483 times
hb32d.jpg
hb32d.jpg (134.34 KiB) Viewed 4483 times
Can someone say what's changed (because it looks for the library format) and how to fix it to work?

Re: Oracle and HMG, can we fix it

Posted: Fri Oct 20, 2017 7:51 am
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 ?

Re: Oracle and HMG, can we fix it

Posted: Fri Oct 20, 2017 2:08 pm
by srvet_claudio
Insert in you .hbp file:

YouTest.prg
sddoci.hbc
rddsql.hbc

See:
http://harbourlanguage.blogspot.com/201 ... 2.html?m=1