Exporting Base to another DB format

[sockerdad]

I am attempting to use Base with Coldfusion, but it only accepts the following database types (I've already tried defing the Base db as each of these to no avail):

• Apache Derby Client
  Apache Derby Embedded
  DB2 Universal Database
  Informix
  J2EE Datasource (JDNI)
  Microsoft Access
  Microsoft Access with Unicode
  Microsoft SQLServer
  MySQL (4/5)
  MySQL (Datadirect)
  ODBC Socket
  Oracle
  Postgre SQL
  Sybase

Now there is an "other", but to use this, I need to know the JDBC URL and the Driver Class,neither of which I have been able to determine.

Any suggestions?

[TheGurkha]

Base isn't a database, it is a bridge between (on the one hand) a database program (server), that program's databases (tables, fieldds and data) and (on the other hand) OOo documents.

A database program is bundled in with OOo, which is the default 'back end' that is used with Base. This is HSQLDB.

You can use many other databases, such as say MySQL. Install MySQL and create your database in MySQL. Then use Base to access that database from within OOo if that is also a requirement. You can then use your MySQL (or PostGRES, etc etc) database with Coldfusion, as it is already in one of the supported formats.

[sockerdad]

OK - that makes sense. Thanks!