[Gambas-user] Compilation hangs on QT4 with Ubuntu 18.04.

[d4t4full at gmail.com]

(again top posting from my cell)

It was the damned "-j" in make that caused the hangs. It even hung later in the compile-cicle when I disabled QT4 as Bruce suggested.

On a wild hunch, I took the "-j" away and restarted compilation with "./reconf-all", "./configure -C --disable-keyring", and plain old "make". Everything went smooth. Next I "sudo make install" and I now have G3 working from sources.

Brought my old ODBC Tester project back to the VM and connected successfully trough the Internet to a MSSQL server in the office.

I'll try to see what's wrong with MDB under ODBC this weekend, but it seems to have to do with mdb-tools apparently not supporting cursors. Cursors is what I used to get row count.

I developed some time ago a very basic isql-like app in C using what I learnt from Gambas-ODBC. It also fails retrieving data from MDB and AccDB files, yet it works correctly with MSSQL, SQLite, and Firebird.

Again, foul play is suspected from the driver, maybe cursors are all that is missing.

If i get this other app to work with Mdb/Accdb files without breaking the rest, I may be able to make it work on Gambas.

Regards,
zxMarce.

On Apr 1, 2021, 11:48, at 11:48, PICCORO McKAY Lenz <mckaygerhard at gmail.com> wrote:
>The ODBC and freeDTS combination is broken in gamas.. there's a active
>threat with that problem and a open issue in gambas bugtracker..
>
>http://gambaswiki.org/bugtracker/edit?object=BUG.1324&from=L21haW4-
>
>While (rs.Available) ' <--- NERE receive null
>Lenz McKAY Gerardo (PICCORO)
>http://qgqlochekone.blogspot.com
>
>Lenz McKAY Gerardo (PICCORO)
>http://qgqlochekone.blogspot.com
>
>
>El mar, 30 de mar. de 2021 a la(s) 10:37, Bruce Steers
>(bsteers4 at gmail.com)
>escribió:
>
>> if 18.04 has qt5 then you could disable qt4 at ./configure
>>
>> ./configure -C --disable-keyring --disable-qt4
>>
>>
>>
>> On Tue, 30 Mar 2021 at 03:13, ML <d4t4full at gmail.com> wrote:
>>
>>> Guys,
>>>
>>> Spent last weekend trying to revive the 20GB VirtualVox VM that I
>set up
>>> and used to patch gb.db.odbc several years ago (from SVN!).
>>> Long story short, I had to switch it from Ubuntu 16.04 32bit to
>Ubuntu
>>> 18.04 64bit; so pretty much had to recreate it.
>>> This last step obliterated the Firebird setup I created to fix row
>count
>>> on it, but I'm confident I can get it back up.
>>>
>>> I had to refork my copy of Gambas in GitLab too, thanks to not
>having
>>> re-synced it for quite some time...
>>> In doing this, I set up the "dual remote repo" recommended in the
>new
>>> CONTRIBUTING file and Wiki to have the repos easily synced.
>>>
>>> (just in case, the pages I read are
>http://gambaswiki.org/wiki/install
>>> and http://gambaswiki.org/wiki/howto/contribute)
>>>
>>> Also got unixODBC and all its glory -and gory- bits installed, along
>>> with FreeTDS for astonishing MSSQL connectivity.
>>>
>>> Then, I got to the gambas workflow: "sudo apt install
><dependencies>",
>>> "./reconf-all", "./configure -C --disable-keyring", you know: the
>works.
>>>
>>> Next I proceeded with "make -j" as said in the wiki. It all went
>nice
>>> and easy until it got to (try to) compile the QT4 components.
>>> This step simply hangs the whole Virtual Machine. Not even the mouse
>>> pointer responds. Dead as a brick. Have to hit RESET on VirtualBox
>to
>>> restart it.
>>> In doing this compilation, it does get through a bunch of QT4 stuff,
>but
>>> it always get to some component or another and just freezes. Tried 4
>or
>>> 5 times.
>>> Not always freezes on the same component, and subsequent attempts to
>>> compile even skip modules already compiled (expected). But again
>dies
>>> processing QT4.
>>>
>>> Searched the interwebs, but could not get to a reasonable response
>or
>>> reason as to why this happens, much less a solution.
>>>
>>> Does anyone have a clue as to why this may happen and, maybe, how to
>>> solve it?
>>>
>>> TIA,
>>> zxMarce.
>>>
>>>
>>> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----
>>>
>>
>> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----
>>
>
>
>------------------------------------------------------------------------
>
>
>----[ http://gambaswiki.org/wiki/doc/netiquette ]----
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20210402/133092eb/attachment.htm>