[Gambas-user] Help with downgrading to lower version of gambas - postgres problems persist - Solved?

[Richard Terry]

Hi Benoit,

I think I've found the problem and its in our code.

We don't use the Gambas3 data connector, we wrote our own code to set up 
the connection back in 2008 when we started writing EasyGP, at least Ian 
did this part

I took a look at it today and now the error message makes sense.

Part of the code in our subroutine was:

$hconn = New Connection
...... bla bla lots of code inbetween.....doing lots of things
backend_pid = PQbackendPID(Connection.Handle)  [which now generates the 
message "Connection.Handle is not static"]

I'm guessing this was a typo and should have read backend_pid = 
PQbackendPID($hconn.Handle)

Its running now with this change and logs on ok, so hopefully this is 
all it was. Strange it worked for all those years, maybe something was 
'tightened up' after version 3.9

Regards

Richard


On 04/07/18 23:44, Benoît Minisini wrote:
> Le 04/07/2018 à 15:01, PICCORO McKAY Lenz a écrit :
>> I think this bug are same as 
>> http://gambaswiki.org/bugtracker/edit?object=BUG.1331&from=L21haW4- 
>> <http://gambaswiki.org/bugtracker/edit?object=BUG.1331&from=L21haW4->
>>
>> Gambas 3.9 does not have that problem mentioned by richard, since the 
>> cited commits, some DB modules has problems since the commits 
>> https://gitlab.com/gambas/gambas/commit/aa67ba1309bde70e8b528be833ba06a8d124cbd1 
>> <https://gitlab.com/gambas/gambas/commit/aa67ba1309bde70e8b528be833ba06a8d124cbd1> 
>> and 
>> https://gitlab.com/gambas/gambas/commit/e07ac2e4f2588f62bb55aa2b8351a08a810c1586 
>> <https://gitlab.com/gambas/gambas/commit/e07ac2e4f2588f62bb55aa2b8351a08a810c1586> 
>> some databases connection does not work
>>
>> By example some connection to postgres works for me but others not! 
>> and connectins to ODBC does also not work at all
>>
>> Gambas only connects to mysql that means connects to scholar used, 
>> mayor DBMS uses scalar grade such like sybase SAP, Oracle and Postgresql
>>
>> please please fix the bug for 3.11
>>
>> Lenz McKAY Gerardo (PICCORO)
>> http://qgqlochekone.blogspot.com
>>
>
> I have no problem with postgresql, mysql or sqlite.
>
> Can you connect to those databases from the IDE?
>