Re: Error message "No content provider available for URL!"

Frank Schoenheit, Sun Microsystems Germany wrote:
> Hi Dick,
>
>> I've established a database with two tables that appears to be working
>> very well. I'm trying to write a Basic macro that issues a query and
>> generates some statistics from the results. I'm getting a runtime error
>> that says "No content provider available for URL!" Any idea what I'm
>> doing wrong?
>
> This sounds as if you're trying to establish a connection to some
> file-based database, i.e. your connection URL starts with something like
> sdbc:dbase: or sdbc:flat:, and the URL after that prefix is wrong.
>
> Ciao
> Frank
>
Here are the statements in question. The database was created using OOo 
Base and does exist as "C:\RahStuff\Base_Stuff\Cleve_CBC.odb".

Dim DatabaseContext
Dim DataSource
Dim Connection
Dim Statement
Dim ResultSet
Dim sSQL as String
Dim DBaseName as String
DBaseName = "jdbc:hsqldb:file:\C:RahStuff\Base_Stuff\Cleve_CBC.odb"
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
DataSource = DatabaseContext.getByName(DBaseName)
Connection = DataSource.GetConnection("","")
Statement = Connection.createStatement()
'        Following query gets all data records in ascending date within 
CBC species number order
sSQL = "SELECT " & "ABA_NAMES.COMMON_NAME, CBC_DATA_RECS.COUNT_YR, 
CBC_DATA_RECS.SPECIES_COUNT" &_
" FROM CBC_DATA_RECS AS CBC_DATA_RECS, ABA_NAMES AS ABA_NAMES" &_
" WHERE CBC_DATA_RECS.SPEC_NO = ABA_NAMES.CBC_S_NUM" & " ORDER BY 
CBC_DATA_RECS.SPEC_NO ASC, CBC_DATA_RECS.COUNT_YR ASC"
ResultSet = Statement.executeQuery(sSQL)

The error occurs on the "DataSource" statement. The full error msg says:

BASIC runtime error
An exception occurred
Type: com.sun.star.lang.WrappedTargetException
Message: jdbc:hsqldb:file:\C:RahStuff\Base_Stuff\Cleve_CBC.odb
TargetException:
  Type: com.sun.star.ucb.ContentCreationException
  Message: No Content Provider available for given URL!

Dick