Hi Dick,
> DBaseName = "jdbc:hsqldb:file:\C:RahStuff\Base_Stuff\Cleve_CBC.odb"
> DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
> DataSource = DatabaseContext.getByName(DBaseName)
replace
DBaseName = "jdbc:hsqldb:file:\C:RahStuff\Base_Stuff\Cleve_CBC.odb"
with
DBaseName = ConvertURL( "C:RahStuff\Base_Stuff\Cleve_CBC.odb" )
The "jdbc:*" and "sdbc:*" URLs are for usage with the DriverManager,
they describe a "connection resource". Your code, however, passes it to
the DatabaseContext, whose getByName expects either the registration
name of a data source, or a URL to an .odb file. Those latter URLs have
nothing to do with the sdbc/jdbc URLs to be used with the DriverManager.
Ciao
Frank
--
- Frank Schönheit, Software Engineer [email protected] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
