[Gambas-bugtracker] Bug #3209: When using db2, and basing the connection for the Datasource on the connection1 it fails when password is required

[<bugtracker@xxxxxxxxxxxxxx>]

http://gambaswiki.org/bugtracker/edit?object=BUG.3209&from=L21haW4-

Comment #1 by Brian G has been edited:

ok, to make a point the Datasource is opened immediately upon reference even before the window is opened. the desktop class is loaded and always returns password disabled.

The connections array is read only so it is not possible to insert the password before the window is opened, I tried does not work lol.

if you try to open a connection and then assign it to the datasource then the system initializes it upon reference even when trying to assign the new one to it.... again lol!

So it seems to be catch 22 here, if you use a connection defined in the ide there is no way to assign the password before it opens, there is no way to assign a new connection without the system getting the error because just trying to assign a new connection causes the ide created connection to open and fail.

so your back to in the ide not assigning a connection and having to do the old remember the field names jive.

The best way to fix this would be to allow connections.create() to pass a password or some extension of connections to allow read write to the password field of a connection, 
Or perhaps allow some database init event or method to be called before the connection is opened that can change the loaded IDE connection parameters.

Or maybe I am completely wrong and just need to be directed...  the docs don't seem to help much!



----[ Gambas bugtracker-list is hosted by https://www.hostsharing.net ]----