Hi Fernand,
On Tue, Nov 15, 2011 at 11:35:35AM +0100, Fernand Vanrie wrote:
> Ariel ,
>
> As y do not know about C++ and Java i stick to Basic :-)
> Thanks (as always) for the knowledge !
>
> BTW , I am interested in the Gridcontrol , because the Datasource
> browser is not working with a connection made using the
> "DriverManger".
>
> oManager = CreateUnoService("com.sun.star.sdbc.DriverManager")
> oConn = oManager.getConnectionWithInfo(sURL, oParms())
>
> When using the "Database Context" to get a connenction , the
> DataSourceBrowser is working,
>
> I am sure you can explain me why the DatasourceBrowser is not
> working with a connection made from the DriverManager !How were you trying this? Were you trying to pass oConn as value for "ActiveConnection" when loading the DSB? According to the API scpec. http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSourceBrowser.html the DSB does not accept an "ActiveConnection", only these properties from the DataAccessDescriptor http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataAccessDescriptor.html are accepted: * DataAccessDescriptor::DataSourceName * DataAccessDescriptor::Command * DataAccessDescriptor::CommandType * optional DataAccessDescriptor::Selection * optional DataAccessDescriptor::BookmarkSelection * optional DataAccessDescriptor::ResultSet notice that the DataSourceName is not optional, and no ActiveConnection (== you have to give the name of a registered data source). Regards -- Ariel Constenla-Haile La Plata, Argentina
pgpuSKpo8NuJs.pgp
Description: PGP signature
