Re: [dba-dev] How to pass password when opening DatasourceBrowser

2010-10-04 Thread Frank Schönheit
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 connection

Re: [dba-dev] How to pass password when opening DatasourceBrowser

2010-10-04 Thread Frank Schönheit
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 -- ORACLE

Re: [dba-dev] How to pass password when opening DatasourceBrowser

2010-10-01 Thread Fernand Vanrie
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(0).Name

Re: [dba-dev] How to pass password when opening DatasourceBrowser

2010-10-01 Thread Frank Schönheit
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.PropertyValue