How to pass password when opening DatasourceBrowser

Fernand Vanrie <[email protected]> Thu, 30 Sep 2010 16:20:15 +0200
Newsgroups gmane.comp.openoffice.dba.devel
Message-ID <[email protected]>
  For opening a DataSourceBrowser I use following code

      Dim aProps(6) as New com.sun.star.beans.PropertyValue
      aProps(0).Name = "DataSourceName"
      aProps(0).Value = "mysql_native"
      aProps(1).Name = "CommandType"
      aProps(1).Value = 2 ' 0 = tabel , 1 = query , 2 = SQL statement
      aProps(2).Name = "Command"
      aProps(2).Value = "SQL statement"
     aProps(3).Name = "ShowTreeView"
      aProps(3).Value = false
      aProps(4).Name = "ShowTreeViewButton"
      aProps(4).Value = false
      aProps(5).Name = "ShowMenu"
      aProps(5).Value = true
      aProps(6).Name = "EscapeProcessing"
      aProps(6).Value = false
      oDataSourcebrowser = 
frame1.loadComponentFromURL(".component:DB/DataSourceBrowser", 
"_beamer", 0, aProps)

   That works fine excepted that  the user is asked for a "Username" and 
"Password" when  the  datasource is opened !

How can i avoid this behaviour by passing the "username and "password" 
within my code ?
I tryed to use a "ActiveConnection" where the Username and password are 
passed... no luck
Neither "UserName" or "Password" are accepted as arguments ....

Only when de datasource is open (even hidden) on the desktop the 
"UserName" and "Password are no longer asked.

thanks for any hint

Fernand