Hi Fernand,
>> Is your oconn object, by any chance, invalid?
> I can Xray it and it shows all details according to the wanted
> connection, so ??
>
> only passing the password to the com.sun.star.comp.dba.ODatabaseSource
> password property works for me
I'm clueless than :(
Ciao
Frank
--
OR
Hi Fernand,
> You clueless, thats new for me :-)
Damn, that slipped my attention, normally I do not admit that :)
> I am still convinced thats your machine knows the Username and
> passwords, or your sytem is never asking for it :-) ?
If I replace the "getConnection" call to create the connec
Frank,
You clueless, thats new for me :-)
I am still convinced thats your machine knows the Username and
passwords, or your sytem is never asking for it :-) ? But wathever i
kan keep my users away from the tables, and thats wath count.
Thanks again for the interest in my problems.
Fernand
On 1/10/2010 14:51, Frank Schönheit wrote:
Hi Fernand,
Are you sure you didn' tryed with user/password before you tryed the
activeconnection, because OO remembers the connection made by
user/password ?
Yes.
The code who works but is asking for User and pasdword:
Dim aProps(7) as Ne
Hi Fernand,
> Are you sure you didn' tryed with user/password before you tryed the
> activeconnection, because OO remembers the connection made by
> user/password ?
Yes.
> The code who works but is asking for User and pasdword:
>
>
> Dim aProps(7) as New com.sun.star.beans.PropertyValu
Frank,
Found a work around:
I now passes the "password" to the com.sun.star.comp.dba.ODatabaseSource
password property
oDB = CreateUnoService("com.sun.star.sdb.DatabaseContext")
oDB.GetByName("mysql_native").password = "mypassword"
and the databrowser opens silently with the data init.
Frank ,
Are you sure you didn' tryed with user/password before you tryed the
activeconnection, because OO remembers the connection made by
user/password ?
"stays empty"? If you pass an ActiveConnection to the DSB, then it stays
empty, if you don't pass it, then it asks for user/password, an
Hi Fernand,
> Wath i already tryed en yet again tryed
>
> oDB = CreateUnoService("com.sun.star.sdb.DatabaseContext")
> oConn =
> oDB.GetByName("mysql_native").GetConnection("username","password")
>
> Dim aProps(7) as New com.sun.star.beans.PropertyValue
> aProps(0).Name
Hey Frank ,
Thanks for the respons:
Wath i already tryed en yet again tryed
oDB = CreateUnoService("com.sun.star.sdb.DatabaseContext")
oConn =
oDB.GetByName("mysql_native").GetConnection("username","password")
Dim aProps(7) as New com.sun.star.beans.PropertyValue
aProps(
Hi Fernand,
> 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 ,
10 matches
Mail list logo
