Base / Mysql / Automatic connection and authentication

[dme69]

Hello all,

I have a base document whixh connect to a mysql database. It's working great but each time i open this doc and try to see the database OOo is asking me for the user and password of mysql.
I want to be able to connect to the mysql database without this dialog box. Is it possible to have a macro doing this ? And is it possible to have this macro launching each time i open the document ?

I'm really new to OObasic and I need help
Thanks for your help.

Dominique.

[Villeroy]

Anything wrong with the method suggested by probe1 in http://www.oooforum.org/forum/viewtopic.phtml?t=75865

[dme69]

Yes it's not working for me it's still asking for user/password ?

[Villeroy]

I may be wrong, but I think, the database tries to establish it's own connection instead of using the one established by the macro. My problem is, that a desktop with OpenOffice.org is not enough to test the issue.

[dme69]

i just try here at home and it is the same problem ...

[dme69]

Hello all.

I don't know if it is a good idea but ... it seems to work ...

I had that to the connection macro :

Code: Select all

oDatenquelle.Password = "myPassword"

It seems to work.